Verifying Resource Consumer Group Membership of Users : dba_users « System Tables Views « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Tables Views
  3. dba_users

Verifying Resource Consumer Group Membership of Users

   
SQL>
SQL> SELECT username, initial_rsrc_consumer_group
  2  FROM dba_users;

USERNAME                       INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ------------------------------
JAVA2S                         DEFAULT_CONSUMER_GROUP
SYS                            SYS_GROUP
SYSTEM                         SYS_GROUP
ANONYMOUS                      DEFAULT_CONSUMER_GROUP
MDSYS                          DEFAULT_CONSUMER_GROUP
OUTLN                          DEFAULT_CONSUMER_GROUP
DIP                            DEFAULT_CONSUMER_GROUP
TSMSYS                         DEFAULT_CONSUMER_GROUP
FLOWS_FILES                    DEFAULT_CONSUMER_GROUP
CTXSYS                         DEFAULT_CONSUMER_GROUP
DBSNMP                         DEFAULT_CONSUMER_GROUP

USERNAME                       INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ------------------------------
FLOWS_020100                   DEFAULT_CONSUMER_GROUP
XDB                            DEFAULT_CONSUMER_GROUP
HR                             DEFAULT_CONSUMER_GROUP

14 rows selected.

SQL>








Related examples in the same category

1.Query dba_users table
2.Displaying the Account Status of All Users
3.Query dba_users table for default_tablespace and temporary_tablespace
4.Join dba_users, dba_sys_privs
5.Join dba_users, dba_tab_privs
6.Check user name and password for users