Querying the USER_TAB_PRIVS_MADE data dictionary view : USER_TAB_PRIVS_MADE « System Tables Views « Oracle PL / SQL

1. Oracle PL / SQL
2. System Tables Views
3. USER_TAB_PRIVS_MADE

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>

           
       

Related examples in the same category