Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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>