Oracle PL/SQL/System Tables Views/USER TAB PRIVS MADE
Privileges that you have granted to others on tables in your schema
<source lang="sql">
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>
</source>
Querying the USER_TAB_PRIVS_MADE data dictionary view
<source lang="sql">
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>
</source>