Oracle教程 2023-03-20

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

Oracle 视图 USER_SYS_PRIVS用于存储特定用户具有的系统权限。所有当前用户可用的系统权限可以从此视图中检索：

要使用 USER_SYS_PRIVS 视图，需要登录到 Oracle 数据库实例中，并运行以下 SQL 语句，以检索当前用户拥有的系统权限：

“`SQL
SELECT GRANTEE, PRIVILEGE, ADMIN_OPTION
FROM USER_SYS_PRIVS;
“`

USER_SYS_PRIVS describes system privileges granted to the current user.

Column	Datatype	Description
`USERNAME`	`VARCHAR2(128)`	Name of the user, or `PUBLIC`
`PRIVILEGE`	`VARCHAR2(40)`	System privilege
`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 grant was inherited from another container (`YES`) or not (`NO`)