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

本站中文解释

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

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

SELECT OBJECT_NAME, PRIVILEGE
FROM DBA_UNUSED_OBJPRIVS;

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

REVOKE ON FROM user;

官方英文解释

DBA_UNUSED_OBJPRIVS lists the object privileges (without privilege grant paths) that are not 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 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

See Also:

  • “DBA_UNUSED_OBJPRIVS_PATH” for privilege grant path information for unused object privileges

  • Oracle Database Security
    Guide
    for more information about privilege analysis

  • Oracle Database PL/SQL
    Packages and Types Reference
    for more information about the DBMS_PRIVILEGE_CAPTURE.GENERATE_RESULT procedure


数据运维技术 » Oracle 视图 DBA_UNUSED_OBJPRIVS 官方解释,作用,如何使用详细说明