Description
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.
References
oceanbase.DBA_RSRC_CONSUMER_GROUPS
Columns
| Type | Type | Nullable | Description | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ATTRIBUTE | varchar(128) | NO | The attribute type, which in the current version can be only ORACLE_USER. |
||||||||||
| VALUE | varbinary(128) | NO | The value. When the category is ORACLE_USER, it records the login username. |
||||||||||
| Column | Type | Nullable | Description | --- | --- | --- | --- | CONSUMER_GROUP | varchar(128) | YES | The name of the resource group to which the user is bound. | ||
| STATUS | varchar(128) | NO | The status of the resource group. This parameter is for compatibility purposes only and is currently fixed to NULL. |
Sample query
As the sys tenant, you can query the binding relationships between users and resource groups in the current tenant.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_RSRC_GROUP_MAPPINGS;