Kbase 19268: Oracle Dataserver Supports Automatic Logins OPS$
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
FACT(s) (Environment):
Oracle DataServer
FIX:
The ORACLE DataServer supports automatic logins to ORACLE, using user accounts set on the OS. Automatic logins allow users to use operating system accounts as the basis for ORACLE username. The syntax for granting automatic logins follows:
GRANT <privilege> TO OPS$sysid IDENTIFIED BY <password>
For example, to create an ORACLE DBA user whose system ID is USERTEST, enter:
GRANT DBA TO OPS$USERTEST IDENTIFIED BY TEST
The GRANT syntax for automatic logins is the same as for non-automatic logins except for prefix "OPS$" on the ORACLE username.
The password (TEST, in this example) can be any arbitrary string and can be subsequently changed.
When a user who is logged into the operating system as BSMITH connects to ORACLE, an ORACLE username/password is not required. For example, when "SQLPLUS" command is entered by the user, a username/password prompt is displayed. Pressing RETURN will result in ORACLE searching the dictionary tables for an automatic login username corresponding to the operating system account. In the example above, ORACLE will search for OPS$USERTEST and after ORACLE finds this name, the user is connected to ORACLE.
To suppress the Username/Password prompt, a user can invoke SQL*PLUS followed by "/". Specifically,
sqlplus /
To connect to an ORACLE database through the ORACLE DataServer using automatic login, the username (-U) parameter should be /. No password is required. The following is a sample connect procedure:
connect holder -1.
connect lholder -ld "lholder" -dt ORACLE -U "/" .