Oracle教程 2023-04-07

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

Oracle视图是查询系统表的简便方式，查看特定用户的操作权限，DBA_SYS_PRIVS视图用于查看拥有特殊权限的用户及其权限，包括SYSDBA和SYSOPER等权限。

可以使用以下SQL语句来查看拥有SYSDBA权限的用户：

SELECT *
FROM DBA_SYS_PRIVS
WHERE PRIVILEGE=’SYSDBA’;

DBA_SYS_PRIVS describes system privileges granted to users and roles.

Column	Datatype	Description
`GRANTEE`	`VARCHAR2(128)`	Grantee name, user, or role receiving the grant
`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`)