用户面临MS-Access问题 [英] User facing an issue with MS- Access

问题描述

当前，用户使用MS Access使用到TEST和PROD实例的连接，一切进展顺利.通过使用ABC用户.现在，用户在TEST中遇到APPS用户的问题. 此外，在PROD实例中，用户与用户XYZ有相同的问题.该用户具有选择任何表"权限，因此它应该能够查看表，但不能在MS Access中使用. 请给我们建议.

Currently user using connections to both TEST and PROD instances using MS Access, and everything goes well. By using ABC user. Now user having problems with APPS user in TEST . Also, user having the same problem with user XYZ in PROD instance. This user has the ‘SELECT ANY TABLE’ privilege, so it should be able to see the tables, but doesn’t work from MS Access. Please suggest us.

推荐答案

如果您能够通过SQL连接进行连接(我假设是ODBC)，那么您将使用一组预定义的凭据(即，会通过连接字符串将用户名和密码传递给Access；

If you're able to connect via a SQL connection (I'm assuming ODBC) then you'll be using a predefined set of credentials (i.e. you'll be passing a username and password to Access; probably through the connection string).

可能是，如果您的用户无法直接进入数据库，则其网络(AD?)帐户未配置为具有与ODBC连接相同的提升特权.

Chances are that if your user is unable to get into the database directly, their network (AD?) account is not configured with the same elevated privileges that the ODBC connection has.

这篇关于用户面临MS-Access问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！