Oracle
1Z0-052 · Question #190
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 object
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #190. The question stem and answer options stay visible for context.
Administering User Security
Question
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?
Options
- ARevoke the RESOURCE role from the users.
- BSet the value of the OS_ROLES parameter to TRUE.
- CUse Database Resource Manager to restrict user access to objects.
- DGrant ANY TABLE system privileges again without ADMIN OPTION.
- ESet the value of the O7_DICTIONARY_ACCESSIBILITY parameter to FALSE.
Unlock 1Z0-052 to see the answer
You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#O7_DICTIONARY_ACCESSIBILITY#data dictionary access#ANY TABLE privilege#dictionary security