Note
This view is introduced since OceanBase Database V3.2.4.
Purpose
The oceanbase.DBA_RSRC_GROUP_MAPPINGS view displays the binding relationships between the user and resource groups.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| ATTRIBUTE | varchar(128) | NO | The category. The current version supports only ORACLE_USER. |
| VALUE | varbinary(128) | NO | The value. When the category is ORACLE_USER, the value is the username for login. |
| CONSUMER_GROUP | varchar(128) | YES | The name of the resource group that the user is bound to. |
| STATUS | varchar(128) | NO | The status of the resource group. It is used only for compatibility and the value is fixed to NULL. |
Sample query
In the system tenant, query the binding relationships between users and resource groups in the current tenant.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_RSRC_GROUP_MAPPINGS;
The query result is as follows:
+-----------+-------+-------------------+--------+
| ATTRIBUTE | VALUE | CONSUMER_GROUP | STATUS |
+-----------+-------+-------------------+--------+
| user | root | interactive_group | NULL |
+-----------+-------+-------------------+--------+
1 row in set
References
For information about the resource groups in the current tenant, see oceanbase.DBA_RSRC_CONSUMER_GROUPS.