This section describes how to authenticate an administrative user using password file
authentication.

Preparing to Use Password File Authentication
To enable authentication of an administrative user using password file authentication
you must do the following:
1. If not already created, create the password file using the ORAPWD utility:
ORAPWD FILE=filename PASSWORD=password ENTRIES=max_users
2. Set the REMOTE_LOGIN_PASSWORDFILE initialization parameter to EXCLUSIVE.
(This is the default).
3. Connect to the database as user SYS (or as another user with the administrative
privileges).
4. If the user does not already exist in the database, create the user.
5. Grant the SYSDBA or SYSOPER system privilege to the user:
GRANT SYSDBA to oe;
This statement adds the user to the password file, thereby enabling connection AS
SYSDBA.

使用密码文件认证
1. 如果为创建密码文件,使用orapwd工具
2. 修改初始化参数 REMOTE_LOGIN_PASSWORDFILE 为EXCLUSIVE
3. 以sys用户连接 , 或拥有管理员权限的其他用户
4. 创建用户
5. 赋予sysdba或sysoper权限给创建的用户

[@more@]

ITPub博客

Using Password File Authentication (38)

最新文章