COUNT(*)
----------
1671
SQL> select * from dba_role_privs where grantee = 'SELECT_CATALOG_ROLE';
GRANTEE GRANTED_ROLE ADM DEF
------------------------------ ------------------------------ --- ---
SELECT_CATALOG_ROLE HS_ADMIN_ROLE NO YES
--进一步看看HS_ADMIN_ROLE角色
SQL> select * from dba_sys_privs where grantee = 'HS_ADMIN_ROLE';
no rows selected
SQL> select owner, table_name, privilege, grantable from dba_tab_privs where grantee = 'HS_ADMIN_ROLE';
OWNER TABLE_NAME PRIVILEGE GRA
------------------------------ ------------------------------ ---------------------------------------- ---
SYS HS_FDS_CLASS SELECT NO
SYS HS_FDS_INST SELECT NO
SYS HS_BASE_CAPS SELECT NO
SYS HS_CLASS_CAPS SELECT NO
SYS HS_INST_CAPS SELECT NO
SYS HS_BASE_DD SELECT NO
SYS HS_CLASS_DD SELECT NO
SYS HS_INST_DD SELECT NO
SYS HS_CLASS_INIT SELECT NO
SYS HS_INST_INIT SELECT NO
SYS HS_ALL_CAPS SELECT NO
SYS HS_ALL_DD SELECT NO
SYS HS_ALL_INITS SELECT NO
SYS HS_FDS_CLASS_DATE SELECT NO
SYS DBMS_HS EXECUTE NO
15 rows selected.
SQL> select * from dba_role_privs where grantee = 'HS_ADMIN_ROLE';
no rows selected
SQL>
8.EXECUTE_CATALOG_ROLE 角色, 具有从数据字典中执行部分过程和函数的权利
SQL> select * from dba_sys_privs where grantee = 'EXECUTE_CATALOG_ROLE';
no rows selected
SQL> select count(*) from dba_tab_privs where grantee = 'EXECUTE_CATALOG_ROLE';
COUNT(*)
----------
77
SQL> select * from dba_role_privs where grantee = 'EXECUTE_CATALOG_ROLE';
GRANTEE GRANTED_ROLE ADM DEF
------------------------------ ------------------------------ --- ---
EXECUTE_CATALOG_ROLE HS_ADMIN_ROLE NO YES
SQL>
--End--