Get user privilege from USER_SYS_PRIVS
SQL>
SQL> SELECT * FROM USER_SYS_PRIVS where rownum <10;
USERNAME PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
SYS ANALYZE ANY NO
SYS CREATE RULE YES
SYS DROP ANY RULE YES
SYS ALTER ANY RULE YES
SYS LOCK ANY TABLE NO
SYS CREATE ANY RULE YES
SYS CREATE RULE SET YES
SYS DELETE ANY TABLE NO
SYS EXECUTE ANY RULE YES
9 rows selected.
SQL>
Related examples in the same category