Note
This view is available starting with V3.2.4.
Overview
Displays the binding relationships between users and resource groups in the current tenant.
Columns
Field type |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| ATTRIBUTE | varchar(128) | NO | Category. The current version supports onlyORACLE_USER. |
| VALUE | varbinary(128) | NO | Value. When the category isORACLE_USERrecords the login username. |
| CONSUMER_GROUP | varchar(128) | YES | The name of the resource group to which the user is bound. |
| STATUS | varchar(128) | NO | Resource group status, used only for compatibility. The current value is fixed asNULL. |
Sample query
Query the binding relationships between users and resource groups within 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 resource groups in the current tenant, see oceanbase.DBA_RSRC_CONSUMER_GROUPS.