Oracle 19cでロール(ROLE)を確認する
環境
Oracle 19c(19.3.0.0.0)
書式
SELECT * FROM DBA_ROLE_PRIVS;
操作例
1.表示幅の設定
SQL> set linesize 1000
SQL> column GRANTEE format a30
SQL> column GRANTED_ROLE format a30
SQL> column ADMIN_OPTION format a10
SQL> column DEFAULT_ROLE format a10
SQL> set linesize 1000
SQL> column GRANTEE format a30
SQL> column GRANTED_ROLE format a30
SQL> column ADMIN_OPTION format a10
SQL> column DEFAULT_ROLE format a10
SQL> set linesize 1000 SQL> column GRANTEE format a30 SQL> column GRANTED_ROLE format a30 SQL> column ADMIN_OPTION format a10 SQL> column DEFAULT_ROLE format a10
2.SQL構文の実行
SQL> SELECT GRANTEE,GRANTED_ROLE,ADMIN_OPTION,DEFAULT_ROLE FROM DBA_ROLE_PRIVS;
SQL> SELECT GRANTEE,GRANTED_ROLE,ADMIN_OPTION,DEFAULT_ROLE FROM DBA_ROLE_PRIVS;
SQL> SELECT GRANTEE,GRANTED_ROLE,ADMIN_OPTION,DEFAULT_ROLE FROM DBA_ROLE_PRIVS;
3.実行結果
GRANTEE GRANTED_ROLE ADMIN_OPTI DEFAULT_RO
------------------------------ ------------------------------ ---------- ----------
SYS RESOURCE YES YES
SYS IMP_FULL_DATABASE YES YES
SYS XS_SESSION_ADMIN YES YES
SYS HS_ADMIN_ROLE YES YES
SYS GSM_POOLADMIN_ROLE YES YES
GRANTEE GRANTED_ROLE ADMIN_OPTI DEFAULT_RO
------------------------------ ------------------------------ ---------- ----------
SYS RESOURCE YES YES
SYS IMP_FULL_DATABASE YES YES
SYS XS_SESSION_ADMIN YES YES
SYS HS_ADMIN_ROLE YES YES
SYS GSM_POOLADMIN_ROLE YES YES
GRANTEE GRANTED_ROLE ADMIN_OPTI DEFAULT_RO ------------------------------ ------------------------------ ---------- ---------- SYS RESOURCE YES YES SYS IMP_FULL_DATABASE YES YES SYS XS_SESSION_ADMIN YES YES SYS HS_ADMIN_ROLE YES YES SYS GSM_POOLADMIN_ROLE YES YES