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) ?