Oracle Select Grants.

--Connect as SYSDBA:

SELECT USERNAME, PRIVILEGE FROM USER_SYS_PRIVS
ORDER BY PRIVILEGE;

SELECT GRANTEE, PRIVILEGE FROM DBA_SYS_PRIVS
WHERE LOWER(GRANTEE) = LOWER('USERNAME')
ORDER BY PRIVILEGE;

SELECT * FROM SESSION_PRIVS
ORDER BY PRIVILEGE;
    

Kopieren