@DIV
select
	PRIVILEGE from USER_SYS_PRIVS
 union
select
	PRIVILEGE from ROLE_SYS_PRIVS
 order
 by PRIVILEGE
@END

実行結果の例
@DIV
ALTER PROFILE
ALTER SESSION
ALTER SYSTEM
ALTER TABLESPACE
ALTER USER
CREATE PROCEDURE
CREATE PROFILE
CREATE PUBLIC SYNONYM
CREATE ROLE
CREATE ROLLBACK SEGMENT
CREATE SEQUENCE
CREATE SESSION
CREATE SYNONYM
CREATE TABLE
CREATE TABLESPACE
CREATE TRIGGER
CREATE VIEW
EXECUTE ANY PROCEDURE
SELECT ANY DICTIONARY
SELECT ANY SEQUENCE
SELECT ANY TABLE
@END

※ ストアードプロシージャの処理の為以下の権限が必要です

1) CREATE PROCEDURE
2) EXECUTE ANY PROCEDURE