Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

Get user privilege from USER_SYS_PRIVS

SQL> SQL> SELECT * FROM USER_SYS_PRIVS where rownum <10; USERNAME                       PRIVILEGE                                ADM ------------------------------ ---------------------------------------- --- SYS                            ANALYZE ANY                              NO SYS                            CREATE RULE                              YES SYS                            DROP ANY RULE                            YES SYS                            ALTER ANY RULE                           YES SYS                            LOCK ANY TABLE                           NO SYS                            CREATE ANY RULE                          YES SYS                            CREATE RULE SET                          YES SYS                            DELETE ANY TABLE                         NO SYS                            EXECUTE ANY RULE                         YES 9 rows selected. SQL>