Get AV when connecting to a database under a limited user acct

[cliffchan512]

Hi,

With no access right to the oracle client folder under a limited user account, then i was trying to connect to a database with TOraSess.Connect, i will get AV on this statement. Please advise

Thanks.

[AlexP]

Hello,

Please specify the versions of IDE, ODAC, Oracle server and client, OS.

[cliffchan512]

Hi,

The ODAC version is 9.7.24, Oracle client is administrator 9i2, 10g or 11g and OS is win server 2003 R2. It doesn't matter what client is used. Thanks!

[AlexP]

We can't reproduce the issue. Please specify what right has the user for the folder with client and the user type (guest, normal user, etc.)

[cliffchan512]

Hi,

Our QA said it should be only Oracle client 10gR1, they tried on win 8, win 8.1 or win 2003R2 and encountered the error on the below situation.
1. after installed the oracle client in an admin user acct, then connecting with ODAC would get the error as oracle cilent 10gR1 seems to have the access right on the fresh install. Once the user click on client folder and accept the permission message to access, then it works as normal.
2. Create an user acct with no admin right and then connect would also get the error.

[AlexP]

Try to connect to the server using the SQLPlus standard utility as a user with limited rights - and let us know the result.