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>