Grant 받은 권한을 조회하는 Query

GRANT받은 권한을 조회하는 QUERY

==============================

 

SELECT USERNAME, ROLENAME, PRIVILEGE

FROM (SELECT DECODE(SA1.GRANTEE#, 1, 'PUBLIC', U1.NAME) username,

             SUBSTR(U2.NAME,1,20) rolename,

             SUBSTR(SPM.NAME,1,27) PRIVILEGE

      FROM SYS.SYSAUTH$ SA1,

           SYS.SYSAUTH$ SA2,

           SYS.USER$ U1,

           SYS.USER$ U2,

           SYS.SYSTEM_PRIVILEGE_MAP SPM

      WHERE SA1.GRANTEE# = U1.USER#

      AND SA1.PRIVILEGE# = U2.USER#

      AND U2.USER# = SA2.GRANTEE#

      AND SA2.PRIVILEGE# = SPM.PRIVILEGE

      UNION

      SELECT U.NAME username, NULL rolename, SUBSTR(SPM.NAME,1,27) privilege

      FROM SYS.SYSTEM_PRIVILEGE_MAP SPM, SYS.SYSAUTH$ SA, SYS.USER$ U

      WHERE SA.GRANTEE#=U.USER#

      AND SA.PRIVILEGE#=SPM.PRIVILEGE)

WHERE USERNAME = 'SCOTT';