Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Question about SELECT_CATALOG_ROLE

JhilMar 9 2019 — edited Apr 17 2019

Dear all,

As we know the role  ( 'SELECT_CATALOG_ROLE ) can be granted to users to allow SELECT privileges on all data dictionary views.

Clearly we can understand , 'SELECT_CATALOG_ROLE  is a role

Why associated privileges are not able to query for the role ?

SQL> select role,privilege from role_sys_privs where role='SELECT_CATALOG_ROLE';

no rows selected.

Is it kind of hiding Data ? (ENCAPSULATION) ?

This post has been answered by AndrewSayer on Mar 9 2019
Jump to Answer
Comments
Post Details
Added on Mar 9 2019
12 comments
3,100 views