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> --
1. | Searches for grants made by users other than the table owners | ||
2. | User Table Privileges report |