Oracle教程 2023-02-24

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

本站中文解释

Oracle视图DBA_XS_ENABLED_AUDIT_POLICIES显示当前启用的审核策略，用于表示控制特定XS历史/资源/角色的审核。

可以使用这个视图来跟踪当前的审核配置，识别审核策略是否改变，以及了解哪些策略已被启用。

它可以用来查询启用的审核策略：

SELECT * FROM DBA_XS_ENABLED_AUDIT_POLICIES;

官方英文解释

DBA_XS_ENABLED_AUDIT_POLICIES describes all the audit policies specific to Oracle Database Real Application Security that are enabled to users.

Note:

This view was known as DBA_XS_ENB_AUDIT_POLICIES in Oracle Database 12c Release 1. It was renamed to DBA_XS_ENABLED_AUDIT_POLICIES in Oracle Database 12c Release 2 (12.2.0.1).

Column	Datatype	Description
`POLICY_NAME`	`VARCHAR2(128)`	Name of the audit policy
`ENABLED_OPTION`	`VARCHAR2(15)`	Enabled option of the audit policy. Possible values: `BY USER`: For policies that are enabled on users `EXCEPT USERS`: For policies that are enabled on users `BY GRANTED ROLE`: For policies that are enabled on roles `INVALID`: For policies that are enabled on roles
`ENTITY_NAME`	`VARCHAR2(128)`	Database entity (user name or role name) on which the audit policy is enabled
`ENTITY_TYPE`	`VARCHAR2(7)`	Database entity type. Possible values: `USER`: Indicates that the policy is enabled on a user or users. `ROLE`: Indicates that the policy is enabled on a role or roles.
`SUCCESS`	`VARCHAR2(3)`	Indicates whether the audit policy is enabled for auditing successful events (`YES`) or not (`NO`)
`FAILURE`	`VARCHAR2(3)`	Indicates whether the audit policy is enabled for auditing unsuccessful events (`YES`) or not (`NO`)

本站中文解释

官方英文解释

相关推荐