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