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
dictionary views.
What is the difference between select any dictionary and
select_catalog_role?
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
privileges:
- select any dictionary: This is a system-level
privilege that is always active and allows the grantee to create
objects.
- 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
(tables).
|
|
 |
|
Guarantee your Success!
Oracle is the
world's most complex, robust and flexible database, considered
impossible to master without a mentor.
That's why all BC
Oracle trainers are working professionals, experts in Oracle who
share their tips and secrets. |
|
| |
|
Burleson is the American Team
Note:
This Oracle
documentation was created as a support and Oracle training reference for use by our
DBA performance tuning consulting professionals.
Feel free to ask questions on our
Oracle forum.
Verify
experience!
Anyone
considering using the services of an Oracle support expert should
independently investigate their credentials and experience, and not rely on
advertisements and self-proclaimed expertise. All legitimate Oracle experts
publish
their Oracle
qualifications.
Errata?
Oracle technology is changing and we
strive to update our BC Oracle support information. If you find an error
or have a suggestion for improving our content, we would appreciate your
feedback. Just
e-mail:
 and include the URL for the page.
Copyright ? 1996 - 2012
All rights reserved.
Oracle ?
is the registered trademark of Oracle Corporation.
|
|
