Some non-DBA users in your database have been granted ANY TABLE system privileges and they are able

63: Some non-DBAusers in your database have been granted ANY TABLE system privileges and

they are able toaccess data dictionary base tables. You decide to restrict their access to data

dictionaryobjects.Which method would you adopt to achieve this objective?

A.Revoke the RESOURCErole from the users.

B.Set thevalue of the OS_ROLES parameter to TRUE.

C.Use DatabaseResource Manager to restrict user access to objects.

D.Grant ANY TABLEsystem privileges again without ADMIN OPTION.

E.Set the value ofthe O7_DICTIONARY_ACCESSIBILITY parameter to FALSE.

O7_DICTIONARY_ACCESSIBILITY参数的作用: 

(1)确保sys以sysdba或sysoper登录 

(2)有select any table权限的用户不能访问数据字典基表

A:错误,收回RESOURCE角色权限,回收不能建表等权限,不能实现题目中要求 

B:错误,OS_ROLES设为TRUE指用户拥有的角色由操作系统控制,不能实现题目中要求 

C:错误,资源管理器是限制资源使用的,不能限制访问权限
D:错误,授予权限不能实现题目要求, 加不加ADMIN OPTION都没有用 

E:正确, O7_DICTIONARY_ACCESSIBILITY为FALSE,可以限制有select any table权限的用户不能 访问数据字典