OCP考试052考题:1Z0-V8.02-第33题
最新学讯:近期OCP认证正在报名中,因考试人员较多请尽快报名获取最近考试时间,报名费用请联系在线老师,甲骨文官方认证,报名从速!
我要咨询OCP考试052考题:1Z0-V8.02-第33题,完整题库请点击这里联系老师咨询了解
33. Some non-DBA users in your database have been granted ANY TABLE system privileges and they
are able to access data dictionary base tables. You decide to restrict their access to data dictionary objects.
Which method would you adopt to achieve this objective?
A.Revoke the RESOURCE role from the users.
B.Set the value of the OS_ROLES parameter to TRUE.
C.Use Database Resource Manager to restrict user access to objects.
D.Grant ANY TABLE system privileges again without ADMIN OPTION.
E.Set the value of the O7_DICTIONARY_ACCESSIBILITY parameter to FALSE.
Answer: E
答案解析:
保护数据字典:默认情况下,O7_DICTIONARY_ACCESSIBILITY参数设置为FALSE。
如果没有很好的理由,一定不要更改这个设置,因为这会阻止具有ANY TABLE系统权限的用户访问数据字典的基表。这个参数设置还确保了SYS用户只能以SYSDBA身份登录。