Oracle 视图 DBA_RSRC_CONSUMER_GROUP_PRIVS 官方解释，作用，如何使用详细说明
本站中文解释
Oracle 视图 DBA_RSRC_CONSUMER_GROUP_PRIVS 用于查看指定资源管理中组中每个会话的使用情况。它可以显示计划中的会话、分配给其他会话的组消耗量，当前组中可用的资源，以及其他信息。
要查看 DBA_RSRC_CONSUMER_GROUP_PRIVS 视图的内容，需要使用以下 SQL 语句：
SELECT * FROM dba_rsrc_consumer_group_privs;
这将显示每个组的标识符和授予权限的登录信息。因此，任何希望管理资源组的账户都可以查看这些权限，以便确定更有效地利用组资源。
官方英文解释
DBA_RSRC_CONSUMER_GROUP_PRIVS displays information about all resource consumer groups and the users and roles assigned to them.
The grant referred to in this view and the related view is the grant of the SWITCH_CONSUMER_GROUP object privilege, which is granted using the DBMS_RESOURCE_MANAGER_PRIVS package. This privilege is not granted through the GRANT SQL statement.
Related View
USER_RSRC_CONSUMER_GROUP_PRIVS displays information about the resource consumer groups to which the current user is assigned. This view does not display the GRANTEE column.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
User or role receiving the grant |
|
|
|
Granted consumer group name |
|
|
|
|
Indicates whether the grant was with the |
|
|
|
|
Indicates whether the consumer group is designated as the default for this user or role ( |
See Also:
-
“USER_RSRC_CONSUMER_GROUP_PRIVS”
-
Oracle Database PL/SQL
Packages and Types Reference for more information about theDBMS_RESOURCE_MANAGER_PRIVSpackage
