You can connect to Oracle Database as a privileged user over a local connection or a
secure remote connection in two ways:
■ If the database has a password file and you have been granted the SYSDBA or
SYSOPER system privilege, then you can connect and be authenticated by a
password file.
■ If the server is not using a password file, or if you have not been granted SYSDBA
or SYSOPER privileges and are therefore not in the password file, you can use
operating system authentication. On most operating systems, authentication for
database administrators involves placing the operating system username of the
database administrator in a special group, generically referred to as OSDBA. Users
in that group are granted SYSDBA privileges. A similar group, OSOPER, is used to
grant SYSOPER privileges to users.

本地连接与安全的远程连接
使用授权用户连接而非本地连接或者安全远程连接有如下两种方式
1. 如果数据库使用密码文件且用户被赋予sysdba权限或者sysoper权限 , 那么就能以密码认证
的方式连接.
2. 如果服务器没有使用密码文件或者没有被赋予sysdba或sysoper的权限 , 可使用操作系统认证
.
在大多的操作系统中 , 都是将操作系统用户加入一个特殊的组 : osdba
.该组中的用户拥有sysdba权限
而osoper组中的用户则被赋予了sysoper权限
3. windows中该两组分别为ora_dba , ora_oper

[@more@]

ITPub博客

Local Connections and Secure Remote Connections (36)

最新文章