Query dba_tab_privs table to get table privilege
SQL>
SQL>
SQL> set verify off
SQL> set linesize 78
SQL> set pagesize 9999
SQL> set feedback on
SQL>
SQL>
SQL> column tab format a24 heading "Schema.Object"
SQL> column privilege format a24 heading "Privilege"
SQL> column grantor format a20 heading "Granted By"
SQL> column grantable format a6 heading "Admin?"
SQL>
SQL> select owner || '.' || table_name tab,
2 privilege,
3 grantor,
4 grantable
5 from dba_tab_privs
6 where rownum < 50
7 order by owner, table_name, privilege
8 /
Schema.Object Privilege Granted By Admin?
------------------------ ------------------------ -------------------- ------
SYS.ARGUMENT$ SELECT SYS YES
SYS.CCOL$ SELECT SYS YES
SYS.CDEF$ SELECT SYS YES
SYS.COL$ SELECT SYS YES
SYS.CON$ SELECT SYS YES
SYS.ICOL$ SELECT SYS YES
SYS.INCEXP ALTER SYS NO
SYS.INCEXP DEBUG SYS NO
SYS.INCEXP DELETE SYS NO
SYS.INCEXP DELETE SYS NO
SYS.INCEXP FLASHBACK SYS NO
SYS.INCEXP INDEX SYS NO
SYS.INCEXP INSERT SYS NO
SYS.INCEXP INSERT SYS NO
SYS.INCEXP ON COMMIT REFRESH SYS NO
SYS.INCEXP QUERY REWRITE SYS NO
SYS.INCEXP REFERENCES SYS NO
SYS.INCEXP SELECT SYS NO
SYS.INCEXP UPDATE SYS NO
SYS.INCEXP UPDATE SYS NO
SYS.INCFIL DELETE SYS NO
SYS.INCFIL FLASHBACK SYS NO
SYS.INCFIL INSERT SYS NO
SYS.INCFIL UPDATE SYS NO
SYS.INCVID ALTER SYS NO
SYS.INCVID DEBUG SYS NO
SYS.INCVID DELETE SYS NO
SYS.INCVID DELETE SYS NO
SYS.INCVID FLASHBACK SYS NO
SYS.INCVID INDEX SYS NO
SYS.INCVID INSERT SYS NO
SYS.INCVID INSERT SYS NO
SYS.INCVID ON COMMIT REFRESH SYS NO
SYS.INCVID QUERY REWRITE SYS NO
SYS.INCVID REFERENCES SYS NO
SYS.INCVID SELECT SYS NO
SYS.INCVID UPDATE SYS NO
SYS.INCVID UPDATE SYS NO
SYS.IND$ SELECT SYS YES
SYS.OBJ$ SELECT SYS NO
SYS.OBJ$ SELECT SYS YES
SYS.SYN$ SELECT SYS YES
SYS.SYSAUTH$ SELECT SYS YES
SYS.TAB$ SELECT SYS YES
SYS.TS$ SELECT SYS YES
SYS.USER$ SELECT SYS YES
SYS.USER$ SELECT SYS NO
SYS.USER$ SELECT SYS YES
SYS.VIEW$ SELECT SYS YES
49 rows selected.
SQL>
SQL>
SQL> --
Related examples in the same category