「Oracle 21c」ロールに付与されている権限を確認するサンプル

環境
Windows 11 Pro 21H2 64bit
Oracle Database 21c Express Edition Release 21.0.0.0.0
SQL*Plus: Release 21.0.0.0.0

構文
SELECT * FROM role_sys_privs
ORDER BY role;
ROLE_SYS_PRIVSを利用して、ロールに付与されている権限を確認します。

使用例
SQL構文

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
SELECT
*
FROM
role_sys_privs
ORDER BY
role;
SELECT * FROM role_sys_privs ORDER BY role;
SELECT
    * 
FROM
    role_sys_privs 
ORDER BY
    role;

実行結果

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
ROLE PRIVILEGE ADMIN_OPTION COMMON INHERITED
AQ_ADMINISTRATOR_ROLE CREATE RULE SET YES YES NO
AQ_ADMINISTRATOR_ROLE MANAGE ANY QUEUE YES YES NO
ROLE PRIVILEGE ADMIN_OPTION COMMON INHERITED AQ_ADMINISTRATOR_ROLE CREATE RULE SET YES YES NO AQ_ADMINISTRATOR_ROLE MANAGE ANY QUEUE YES YES NO
ROLE	PRIVILEGE	ADMIN_OPTION	COMMON	INHERITED
AQ_ADMINISTRATOR_ROLE	CREATE RULE SET	YES	YES	NO
AQ_ADMINISTRATOR_ROLE	MANAGE ANY QUEUE	YES	YES	NO

 

Oracle 21c

Posted by arkgame