Page 1 of 1
Get AV when connecting to a database under a limited user acct
Posted: Thu 14 Jul 2016 07:26
by 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.
Re: Get AV when connecting to a database under a limited user acct
Posted: Thu 14 Jul 2016 12:17
by AlexP
Hello,
Please specify the versions of IDE, ODAC, Oracle server and client, OS.
Re: Get AV when connecting to a database under a limited user acct
Posted: Fri 15 Jul 2016 01:39
by 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!
Re: Get AV when connecting to a database under a limited user acct
Posted: Fri 15 Jul 2016 10:03
by 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.)
Re: Get AV when connecting to a database under a limited user acct
Posted: Mon 18 Jul 2016 04:00
by 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.
Re: Get AV when connecting to a database under a limited user acct
Posted: Mon 18 Jul 2016 09:43
by AlexP
Try to connect to the server using the SQLPlus standard utility as a user with limited rights - and let us know the result.