Administrative users can be connected and authenticated to a local or remote database
by using the SQL*Plus CONNECT command. They must connect using their username
and password and the AS SYSDBA or AS SYSOPER clause. For example, user oe has
been granted the SYSDBA privilege, so oe can connect as follows:
CONNECT oe/oe AS SYSDBA
However, user oe has not been granted the SYSOPER privilege, so the following
command will fail:
CONNECT oe/oe AS SYSOPER

Note: Operating system authentication takes precedence over
password file authentication. Specifically, if you are a member of
the OSDBA or OSOPER group for the operating system, and you
connect as SYSDBA or SYSOPER, you will be connected with
associated administrative privileges regardless of the
username/password that you specify.
If you are not in the OSDBA or OSOPER groups, and you are not in
the password file, then attempting to connect as SYSDBA or as
SYSOPER fails.

使用密码文件认证联机
1. 如果用户在OSDBA 或者 OSOPER 组中 , 将忽略用户名和密码
2. 如果用户不在OSDBA 或者 OSOPER 组中 , 并且不在密码文件中 , 以sysdba或
sysoper连接时将出错

[@more@]

ITPub博客

Connecting Using Password File Authentication (39)

最新文章