[Oracle] GRANT 조회

권한 테이블

USER_TAB_PRIVS

부여된 권한 조회 (펑션, 프로시저, 패키지)

SELECT *
FROM USER_TAB_PRIVS
WHERE OWNER = 'USER01'
AND GRANTEE = 'USER02'
AND PRIVILEGE = 'EXECUTE'
ORDER BY TABLE_NAME
;

부여된 권한 조회 (시퀀스)

SELECT *
FROM USER_TAB_PRIVS
WHERE OWNER = 'USER01'
AND GRANTEE = 'USER02'
AND INSTR(TABLE_NAME, 'SEQ') > 0
ORDER BY TABLE_NAME
;

PRIVILEGE 리스트

SELECT
INSERT
UPDATE
DELETE

EXECUTE
DEBUG

ALTER
INDEX
DEQUEUE
FLASHBACK
ON COMMIT REFRESH
QUERY REWRITE
READ
REFERENCES
UNDER
WRITE