Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

Verifying Resource Consumer Group Membership of Users

SQL> SQL> SELECT username, initial_rsrc_consumer_group   2  FROM dba_users; USERNAME                       INITIAL_RSRC_CONSUMER_GROUP ------------------------------ ------------------------------ RNTSOFT                         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>