Oracle教程 2023-02-24

Oracle 视图 ROLE_SYS_PRIVS 官方解释，作用，如何使用详细说明

Oracle视图ROLE_SYS_PRIVS是一个内置视图，它显示了受指定角色授予的系统权限，包括对角色所拥有的权限。

此视图的每行代表一个用户的角色或系统权限，此视图包含受指定角色授予的系统权限，包括对角色所拥有的权限。视图具有以下列：

GRANTED_ROLE：已授予的角色的名称

GRANTEE：授予该权限的用户或角色

ADMIN_OPTION：指示是否具有将权限授予别人的工具

DEFAULT_ROLE：如果已授予角色即为默认角色，则为Y

若要使用这个视图，可以执行如下查询：SELECT GRANTEE,GRANTED_ROLE FROM ROLE_SYS_PRIVS;

此查询将显示每个用户和角色所持有的权限。

ROLE_SYS_PRIVS describes system privileges granted to roles.

Information is provided only about roles to which the user has access.

Column	Datatype	Description
`ROLE`	`VARCHAR2(128)`	Name of the role
`PRIVILEGE`	`VARCHAR2(40)`	System privilege granted to the role
`ADMIN_OPTION`	`VARCHAR2(3)`	Indicates whether the grant was with the `ADMIN` option (`YES`) or not (`NO`)
`COMMON`	`VARCHAR2(3)`	Indicates how the grant was made. Possible values: `YES` if the privilege was granted commonly (`CONTAINER=ALL` was used) `NO` if the privilege was granted locally (`CONTAINER=ALL` was not used)
`INHERITED`	`VARCHAR2(3)`	Indicates whether the role grant was inherited from another container (`YES`) or not (`NO`)

分享到：