Oracle PL/SQL/System Tables Views/user tab privs
Query user_tab_privs
SQL>
SQL>
SQL> desc user_tab_privs;
Name Null? Type
-----------------------------------------------------------------------------------------
GRANTEE NOT NULL VARCHAR2(30)
OWNER NOT NULL VARCHAR2(30)
TABLE_NAME NOT NULL VARCHAR2(30)
GRANTOR NOT NULL VARCHAR2(30)
PRIVILEGE NOT NULL VARCHAR2(40)
GRANTABLE VARCHAR2(3)
HIERARCHY VARCHAR2(3)
SQL> select * from user_tab_privs where rownum < 50;
GRANTEE OWNER TABLE_NAME GRANTOR PRIVILEGE GRA HIE
------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------------------------------------- --- ---
CTXSYS SYS ICOL$ SYS SELECT YES NO
CTXSYS SYS CON$ SYS SELECT YES NO
CTXSYS SYS IND$ SYS SELECT YES NO
CTXSYS SYS COL$ SYS SELECT YES NO
CTXSYS SYS TS$ SYS SELECT YES NO
CTXSYS SYS CCOL$ SYS SELECT YES NO
FLOWS_020100 SYS USER$ SYS SELECT YES NO
XDB SYS USER$ SYS SELECT NO NO
CTXSYS SYS USER$ SYS SELECT YES NO
FLOWS_020100 SYS OBJ$ SYS SELECT NO NO
CTXSYS SYS OBJ$ SYS SELECT YES NO
GRANTEE OWNER TABLE_NAME GRANTOR PRIVILEGE GRA HIE
------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------------------------------------- --- ---
CTXSYS SYS TAB$ SYS SELECT YES NO
CTXSYS SYS CDEF$ SYS SELECT YES NO
CTXSYS SYS SYN$ SYS SELECT YES NO
CTXSYS SYS VIEW$ SYS SELECT YES NO
CTXSYS SYS ARGUMENT$ SYS SELECT YES NO
CTXSYS SYS SYSAUTH$ SYS SELECT YES NO
EXP_FULL_DATABASE SYS INCEXP SYS UPDATE NO NO
EXP_FULL_DATABASE SYS INCEXP SYS INSERT NO NO
EXP_FULL_DATABASE SYS INCEXP SYS DELETE NO NO
SYSTEM SYS INCEXP SYS FLASHBACK NO NO
SYSTEM SYS INCEXP SYS DEBUG NO NO
GRANTEE OWNER TABLE_NAME GRANTOR PRIVILEGE GRA HIE
------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------------------------------------- --- ---
SYSTEM SYS INCEXP SYS QUERY REWRITE NO NO
SYSTEM SYS INCEXP SYS ON COMMIT REFRESH NO NO
SYSTEM SYS INCEXP SYS REFERENCES NO NO
SYSTEM SYS INCEXP SYS UPDATE NO NO
SYSTEM SYS INCEXP SYS SELECT NO NO
SYSTEM SYS INCEXP SYS INSERT NO NO
SYSTEM SYS INCEXP SYS INDEX NO NO
SYSTEM SYS INCEXP SYS DELETE NO NO
SYSTEM SYS INCEXP SYS ALTER NO NO
EXP_FULL_DATABASE SYS INCVID SYS UPDATE NO NO
EXP_FULL_DATABASE SYS INCVID SYS INSERT NO NO
GRANTEE OWNER TABLE_NAME GRANTOR PRIVILEGE GRA HIE
------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------------------------------------- --- ---
EXP_FULL_DATABASE SYS INCVID SYS DELETE NO NO
SYSTEM SYS INCVID SYS FLASHBACK NO NO
SYSTEM SYS INCVID SYS DEBUG NO NO
SYSTEM SYS INCVID SYS QUERY REWRITE NO NO
SYSTEM SYS INCVID SYS ON COMMIT REFRESH NO NO
SYSTEM SYS INCVID SYS REFERENCES NO NO
SYSTEM SYS INCVID SYS UPDATE NO NO
SYSTEM SYS INCVID SYS SELECT NO NO
SYSTEM SYS INCVID SYS INSERT NO NO
SYSTEM SYS INCVID SYS INDEX NO NO
SYSTEM SYS INCVID SYS DELETE NO NO
GRANTEE OWNER TABLE_NAME GRANTOR PRIVILEGE GRA HIE
------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------------------------------------- --- ---
SYSTEM SYS INCVID SYS ALTER NO NO
EXP_FULL_DATABASE SYS INCFIL SYS UPDATE NO NO
EXP_FULL_DATABASE SYS INCFIL SYS INSERT NO NO
EXP_FULL_DATABASE SYS INCFIL SYS DELETE NO NO
SYSTEM SYS INCFIL SYS FLASHBACK NO NO
49 rows selected.
SQL>