Oracle教程 2023-04-05

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

本站中文解释

Oracle视图DBA_USED_SYSPRIVS用于查询每个用户已使用的系统特权，以及它们可以执行的特定操作，这些操作比用户拥有的表和索引细分程度更高。

此信息可用于更有效地控制表和列级安全性、特定操作和批处理进程。

使用方法：

1. 链接到Oracle服务器

2. 运行以下查询，显示某个用户已使用过的系统特权和对应的资源：

SELECT *
FROM DBA_USED_SYSPRIVS
WHERE GRANTEE = ‘username’;

3. 在返回值中，查看每个PRIVILEGE和RESOURCE找到已使用的特殊特权及它们之间的关系。

官方英文解释

DBA_USED_SYSPRIVS lists the system privileges (without privilege grant paths) that are used for the privilege analysis policies reported by the DBMS_PRIVILEGE_CAPTURE.GENERATE_RESULT procedure.

This view provides access to analyzed privilege records in SYS tables.

You must have the CAPTURE_ADMIN role to access this view.

Column	Datatype	NULL	Description
`CAPTURE`	`VARCHAR2(128)`	`NOT NULL`	Name of a privilege analysis policy
`SEQUENCE`	`NUMBER`	`NOT NULL`	The sequence number of the privilege analysis run during which the privilege was used
`OS_USER`	`VARCHAR2(128)`		Operating system login username
`USERHOST`	`VARCHAR2(128)`		Client host machine name
`MODULE`	`VARCHAR2(64)`		Module name
`USERNAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the user whose privilege was reported
`USED_ROLE`	`VARCHAR2(128)`		Used role
`SYS_PRIV`	`VARCHAR2(40)`		Used system privilege
`ADMIN_OPTION`	`NUMBER`		Indicates whether the `ADMIN` option was used: `0` – Indicates that the `ADMIN` option was not used `1` – Indicates that the `ADMIN` option was used
`RUN_NAME`	`VARCHAR2(128)`		The name of the run during which the privilege was reported

本站中文解释

官方英文解释

相关推荐