Oracle PL/SQL/System Tables Views/USER ROLE PRIVS

Материал из SQL эксперт
Перейти к: навигация, поиск

Lists the roles that have been granted to the user

   <source lang="sql">

SQL> --Lists the roles that have been granted to the user SQL> SQL> desc USER_ROLE_PRIVS;

Name                                                                                                  Null?    Type
----------------------------------------------------------------------------------------------------- -------- --------------------------------------------------------------------
USERNAME                                                                                               VARCHAR2(30)
GRANTED_ROLE                                                                                           VARCHAR2(30)
ADMIN_OPTION                                                                                           VARCHAR2(3)
DEFAULT_ROLE                                                                                           VARCHAR2(3)
OS_GRANTED                                                                                             VARCHAR2(3)

SQL> SQL> select * from USER_ROLE_PRIVS where rownum < 200; USERNAME GRANTED_ROLE ADM DEF OS_


------------------------------ --- --- ---

sqle DBA NO YES NO SQL> SQL>

      </source>
   
  


See which roles are available for you

   <source lang="sql">

SQL> --See which roles are available for you SQL> SQL> SELECT GRANTED_ROLE FROM USER_ROLE_PRIVS; GRANTED_ROLE


DBA SQL> SQL>

      </source>