Get user privilege from USER_SYS_PRIVS : USER_SYS_PRIVS « System Tables Views « Oracle PL / SQL






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>

           
       








Related examples in the same category