Does Toad work with or support Oracle Advanced Security (OAS) or Advanced Security Option (ASO)? Will Toad allow to connect to the Oracle database without giving a username or password, since it is externally authenticated?
Vintela allows to connect to the Unix server with wintel desktop name and password.
ASO connection would look like this in SQL Plus:
sqlplus /@STDV
Username and password are authenticated from Active Directory and Kerberos.
Toad allows operating system authenticated users whose user names and passwords are external. The Oracle default prefix is usually OPS$.
How to set it up:
1. Go to Oracle parameters and make note of the OS_AUTHENT_PREFIX string.
2. Create a user with that string (usually OPS$) in front of the Windows user name. For example: OPS$JSMITH.
3. Choose "Use operating system authentication" so that the password fields are grayed out and finish creating the user.
4. Now a user can login in Toad from his/her machine and leave the user name and password blank.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center