Oracle 视图 DBA_RSRC_MANAGER_SYSTEM_PRIVS 官方解释，作用，如何使用详细说明
本站中文解释
:
Oracle视图DBA_RSRC_MANAGER_SYSTEM_PRIVS用于查询系统资源管理员分配的系统权限。此视图列出每个系统资源管理员的系统权限，以及其分配给分配给执行此操作的资源管理员的用户名和系统权限的有效日期。
使用这个视图的方法如下：
SELECT *
FROM DBA_RSRC_MANAGER_SYSTEM_PRIVS
WHERE grantee_name = ”
AND privilege =
官方英文解释
DBA_RSRC_MANAGER_SYSTEM_PRIVS displays information about all the users and roles that have been granted the ADMINISTER_RESOURCE_MANAGER system 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_MANAGER_SYSTEM_PRIVS displays information about the users who are granted system privileges for the DBMS_RESOURCE_MANAGER package. This view does not display the GRANTEE column.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
User or role receiving the grant |
|
|
|
|
Name of the system privilege |
|
|
|
Indicates whether the grant was with the |
See Also:
-
“USER_RSRC_MANAGER_SYSTEM_PRIVS”
-
Oracle Database PL/SQL
Packages and Types Reference for more information about theDBMS_RESOURCE_MANAGERpackage
