Query dba_tab_privs table to get table privilege : dba_tab_privs « System Tables Views « Oracle PL / SQL






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

1.Searches for grants made by users other than the table owners
2.User Table Privileges report