Oracle PL/SQL/System Tables Views/USER TAB PRIVS MADE
Privileges that you have granted to others on tables in your schema
SQL>
SQL> -- Privileges that you have granted to others on tables in your schema
SQL>
SQL> SELECT * FROM USER_TAB_PRIVS_MADE;
no rows selected
SQL>
Querying the USER_TAB_PRIVS_MADE data dictionary view
SQL>
SQL>
SQL> -- Querying the USER_TAB_PRIVS_MADE data dictionary view
SQL>
SQL> SELECT * FROM USER_TAB_PRIVS_MADE where rownum < 10;
GRANTEE TABLE_NAME
------------------------------ ------------------------------
GRANTOR PRIVILEGE GRA HIE
------------------------------ ---------------------------------------- --- ---
OEM_MONITOR ALERT_QUE
SYS DEQUEUE NO NO
PUBLIC ALERT_TYPE
SYS EXECUTE NO NO
PUBLIC ALL_ALL_TABLES
SYS SELECT YES NO
GRANTEE TABLE_NAME
------------------------------ ------------------------------
GRANTOR PRIVILEGE GRA HIE
------------------------------ ---------------------------------------- --- ---
PUBLIC ALL_APPLY
SYS SELECT YES NO
PUBLIC ALL_APPLY_CONFLICT_COLUMNS
SYS SELECT YES NO
PUBLIC ALL_APPLY_DML_HANDLERS
SYS SELECT YES NO
GRANTEE TABLE_NAME
------------------------------ ------------------------------
GRANTOR PRIVILEGE GRA HIE
------------------------------ ---------------------------------------- --- ---
PUBLIC ALL_APPLY_ENQUEUE
SYS SELECT YES NO
PUBLIC ALL_APPLY_ERROR
SYS SELECT YES NO
PUBLIC ALL_APPLY_EXECUTE
SYS SELECT YES NO
9 rows selected.
SQL>
SQL>
SQL>