Which method would you adopt to achieve this objective?

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?

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.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Koro

Koro

Explanation:
Protect the data dictionary. Ensure that users with the SELECT ANY TABLE privilege cannot
access the tables that underlie the data dictionary by setting O7_DICTIONARY_ACCESSIBILITY =
FALSE . This is the default setting.