Oracle教程 2023-02-24

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

Oracle视图DBA_UNUSED_OBJPRIVS用来查询出所有未使用的对象权限。它包含一个列，其中列为权限类型。通过查看这个列，可以轻松查出那些未被使用的权限。

DBA_UNUSED_OBJPRIVS可以用于移除没有使用的对象权限，从而提高数据库安全性。要使用这个视图，可以使用下面的语句：

SELECT OBJECT_NAME, PRIVILEGE
FROM DBA_UNUSED_OBJPRIVS;

这句SQL用于查询出所有未使用的对象权限。查询完毕后，可以通过执行一条以下的SQL语句来移除没有被使用的权限：

REVOKE ON

Column	Datatype	NULL	Description
`CAPTURE`	`VARCHAR2(128)`	`NOT NULL`	Name of the privilege analysis policy
`USERNAME`	`VARCHAR2(128)`		Name of the user whose privileges are reported
`ROLENAME`	`VARCHAR2(128)`		Name of the role whose unused privileges are reported (for `ROLE` type privilege analysis or `ROLE AND CONTEXT` privilege analysis)
`OBJ_PRIV`	`VARCHAR2(40)`		Unused object privilege
`OBJECT_OWNER`	`VARCHAR2(128)`		Object owner
`OBJECT_NAME`	`VARCHAR2(128)`		Name of the object that `USERNAME` has `OBJ_PRIV` on
`OBJECT_TYPE`	`VARCHAR2(23)`		Type of the object `USERNAME` has `OBJ_PRIV` on
`COLUMN_NAME`	`VARCHAR2(128)`		Name of the column that `USERNAME` has `OBJ_PRIV` on
`GRANT_OPTION`	`NUMBER`		Indicates whether the privilege is granted with the `GRANT` option: `0` – Indicates that the privilege is granted without the `GRANT` option `1` – Indicates that the privilege is granted with the `GRANT` option
`RUN_NAME`	`VARCHAR2(128)`		The name of the run during which the privilege was reported

分享到：