@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
|