Lists the roles that have been granted to the user : USER_ROLE_PRIVS « System Tables Views « Oracle PL / SQL






Lists the roles that have been granted to the user



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_
------------------------------ ------------------------------ --- --- ---
JAVA2S                         DBA                            NO  YES NO

SQL>
SQL>
           
       








Related examples in the same category

1.See which roles are available for you