Installing and managing Oracle database
To use operating system authentication, set
REMOTE_LOGIN_PASSWORDFILE parameter to NONE (default).
OS authenticated users can connect as CONNECT / AS SYSDBA (or SYSOPER).
When using password file authentication, users connect to database by specifying username and password.
1. Using ORAPWD utility, create a password file with SYS password.
2. Set REMOTE_LOGIN_PASSWORDFILE parameter.
3. Grant appropriate users SYSDBA or SYSOPER privilege.
REMOTE_LOGIN_PASSWORDFILE parameter to NONE (default).
OS authenticated users can connect as CONNECT / AS SYSDBA (or SYSOPER).
When using password file authentication, users connect to database by specifying username and password.
1. Using ORAPWD utility, create a password file with SYS password.
2. Set REMOTE_LOGIN_PASSWORDFILE parameter.
3. Grant appropriate users SYSDBA or SYSOPER privilege.
No comments:
Post a Comment