QUESTION 84-orapwd/entries

最新推荐文章于 2022-05-28 19:50:17 发布

黄继生 jisen

最新推荐文章于 2022-05-28 19:50:17 发布

阅读量151

点赞数

分类专栏： 060

本文链接：https://blog.csdn.net/jisen_huang/article/details/114140329

版权

060 专栏收录该内容

230 篇文章 2 订阅

订阅专栏

You executed this command to create a password file:
$ orapwd file = orapworcl entries = 10 ignorecase = N
Which two statements are true about the password file?
A. It will permit the use of uppercase passwords for database users who have been granted the SYSOPER role.
B. It contains username and passwords of database users who are members of the OSOPER operating system group.
C. It contains usernames and passwords of database users who are members of the OSDBA operating system group.
D. It will permit the use of lowercase passwords for database users who have granted the SYSDBA role.
E. It will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role.
Correct Answer: AD

A.它将允许已被授予SYSOPER角色的数据库用户使用大写密码。

e.它将允许授予SYSDBA角色的数据库用户使用小写密码。

entries
可选项，entries是可以保存的记录个数，每个具有sysdba或sysoper权限的用户算一个记录。如果一个用户同时具有sysdba和sysoper的权限，则只占一个记录。
对应于允许以SYSDBA/SYSOPER权限登录数据库的最大用户数，如果用户数超过这个值只能重建密码（口令)文件，增大entries 数据库启动后可以通过v$pwfile_users来查看密码文件中记录的情况

* You can create a password file using the password file creation utility, ORAPWD.
* Adding Users to a Password File
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.
* The syntax of the ORAPWD command is as follows:
ORAPWD FILE=filename [ENTRIES=numusers]
[FORCE={Y|N}] [IGNORECASE={Y|N}] [NOSYSDBA={Y|N}]
* IGNORECASE
If this argument is set to y, passwords are case-insensitive. That is, case is ignored when comparing the password that the user supplies during login with the password in the password file.