We are implementing Oracle Enterprise User Security (EUS) using Oracle Virtual Directory (OVD). Database users will be authenticated against Active Directory. They log into the database using TOAD and their OS user ID and Password. There are no physical user ids in the database, just a GLOBAL_USER. All permissions are managed using Global roles, enterprise roles and AD groups.
The issue I am experiencing is that when the user logs into the database, TOAD appears to be saving the connection information (user id and password) from the database as GLOBAL_USER and the password instead of the user id that was used to actually log in. Older versionof TOAD do not do this. Some users around here still have 9.7.2 and it seems to save the login information correctly.
Here is an explaination of what is happening.
Database=ORCL, userid = u01234, password=abc123
Oracle EUS verifies in AD/OVD that the account can access the database what roles/access it has.
Database login appears as: username=GLOBAL_USER, osuser=u01234 - which is as it should look
Toad saves the connection as GLOBAL_USER ORCL, instead of u01234 ORCL
I can manually fix it by editing the login record in the login pop up window and save it, but I want to know is there a way to get TOAD to save the right information in the first place, so I don’t have to manually edit everytime I connect to a new database.