Tip on using the 07_DICTIONARY_ACCESSIBILITY initialization parameter
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
Tip on using the 07_DICTIONARY_ACCESSIBILITY initialization parameter
Rating:
When a privilege on ANY object, such as CREATE ANY CLUSTER is granted, the result is determined by the value of the O7_DICTIONARY_ACCESSIBILITY initialization parameter. The default value of the parameter is FALSE. The consequence of the default value is that the ANY privilege gives a grantee access to the specified type of object in all schemas except the SYS schema. If the O7_DICTIONARY_ACCESSIBILITY parameter is set to TRUE, the ANY privilege also gives the grantee access to all objects in the SYS schema except Scheduler objects. For security reasons, Oracle recommends to use the setting of the parameter with great caution.
Rating:
Was this information helpful?
Other articles
- THE FLASHBACK OPERATIONS
- What is the EXTRACT function?
- What is iSQL*Plus?
- Tip on naming a constraint.
- Tip on DUAL