Question: I see that select any
dictionary seems to have the same ability as the
select_catalog_role for read-only privileges against the data
What is the difference between select any dictionary and
Answer: The differences are subtle between
select any dictionary and select_catalog_role.
It comes down to the difference between the properties of a
system-level privilege and a role.
Remember, a role is a collection of system-level or object-level
- select any dictionary: This is a system-level
privilege that is always active and allows the grantee to create
- select_catalog_role: This is a role, which is a
collection of privileges. A role can be specifically enabled or
disabled and this role cannot be used to create any objects
Get the Complete
Oracle SQL Tuning Information
The landmark book
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.