Note
This view is available starting with V3.2.4.
Purpose
This view displays the relationships between users and resource groups under the current tenant.
References
oceanbase.DBA_RSRC_CONSUMER_GROUPS
Columns
| Type | Type | Nullable | Description | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ATTRIBUTE | varchar(128) | NO | The category. Only ORACLE_USER is supported in the current version. |
||||||||||
| VALUE | varbinary(128) | NO | 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 field is reserved and always has the NULL value. |
Sample query
User tenants can query the binding between users and resource groups in the tenant.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_RSRC_GROUP_MAPPINGS;