Note
This view is available starting with V3.2.4.
Purpose
This view displays the binding relationships between users and resource groups in the current tenant.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| ATTRIBUTE | VARCHAR2(128) | NO | The category. In the current version, only ORACLE_USER is supported. |
| VALUE | VARBINARY(128) | NO | The value. When the category is ORACLE_USER, this column records the login username. |
| CONSUMER_GROUP | VARCHAR2(128) | YES | The name of the resource group to which the user is bound. |
| STATUS | VARCHAR2(128) | NO | The status of the resource group. This column is reserved for compatibility. Its value is fixed to NULL. |
Sample query
Query the binding relationships between users and resource groups in the user tenant.
obclient [SYS]> SELECT * FROM SYS.DBA_RSRC_GROUP_MAPPINGS;
The query result is as follows:
+-----------+-------+-------------------+--------+
| ATTRIBUTE | VALUE | CONSUMER_GROUP | STATUS |
+-----------+-------+-------------------+--------+
| user | sys | interactive_group | NULL |
+-----------+-------+-------------------+--------+
1 row in set
References
To query information about resource groups in the current tenant, see DBA_RSRC_CONSUMER_GROUPS.