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.
Set the value of the OS_ROLES parameter to TRUE.

B.
Set the value of the O7_DICTIONARY_ACCESSIBILITY parameter to FALSE.

C.
Revoke the RESOURCE role from the users.

D.
Grant ANY TABLE system privileges again without ADMIN OPTION.

E.
Use Database Resource Manager to restrict user access to objects.



Leave a Reply 1

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