Oracle PL/SQL/System Tables Views/USER SYS PRIVS

Get user privilege from USER_SYS_PRIVS

   <source lang="sql">

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>

      </source>