Adding Users to a Password File (46)

When you grant SYSDBA or SYSOPER privileges to a user, that user's name and
privilege information are added to the password file. If the server does not have an
EXCLUSIVE password file (that is, if the initialization parameter
REMOTE_LOGIN_PASSWORDFILE is NONE or SHARED, or the password file is missing),
Oracle Database issues an error if you attempt to grant these privileges.

A user's name remains in the password file only as long as that user has at least one of
these two privileges. If you revoke both of these privileges, Oracle Database removes
the user from the password file.

添加用户至密码文件
1. 如果REMOTE_LOGIN_PASSWORDFILE参数不为空 , 不能赋予sysdba权限给用户
2. 只要拥有sysdba后者sysoper权限 , 用户明将保留在密码文件中

[@more@]
请使用浏览器的分享功能分享到微信等