[Oracle] 부여된 권한 조회

 

SELECT
    OWNER
    , (
        SELECT DISTINCT REPLACE(OBJECT_TYPE, ' BODY', '')
        FROM USER_OBJECTS
        WHERE OBJECT_NAME = A.TABLE_NAME
    ) OBJECT_TYPE
    , TABLE_NAME OBJECT_NAME
    , GRANTOR, GRANTEE, PRIVILEGE, GRANTABLE, HIERARCHY
FROM USER_TAB_PRIVS A
WHERE OWNER = 'SCOTT'
ORDER BY OWNER, OBJECT_TYPE, TABLE_NAME, GRANTOR, GRANTEE, PRIVILEGE
;