Oracle 11G OCP 1Z0-052 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.

答案：（E）

解析：

B（X），OS_ROLES確定是由Oracle（FALSE）還是作業系統（TRUE）來識別和管理每個使用者的角色。

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17013648/viewspace-1178445/，如需轉載，請註明出處，否則將追究法律責任。