审计策略ORA_SECURECONFIG

oracle里默认激活的审计策略只有两个ORA_SECURECONFIG和ORA_LOGON_FAILURES,其中ORA_SECURECONFIG这个审计策略记录的信息较多

CREATE AUDIT POLICY ORA_SECURECONFIG
 PRIVILEGES ALTER ANY TABLE, CREATE ANY TABLE, DROP ANY TABLE,
            CREATE ANY PROCEDURE, DROP ANY PROCEDURE, ALTER ANY PROCEDURE, 
            GRANT ANY PRIVILEGE, GRANT ANY OBJECT PRIVILEGE, GRANT ANY ROLE, 
            AUDIT SYSTEM, CREATE EXTERNAL JOB, CREATE ANY JOB, 
            CREATE ANY LIBRARY, 
            EXEMPT ACCESS POLICY, 
            CREATE USER, DROP USER, 
            ALTER DATABASE, ALTER SYSTEM, 
            CREATE PUBLIC SYNONYM, DROP PUBLIC SYNONYM, 
            CREATE SQL TRANSLATION PROFILE, CREATE ANY SQL TRANSLATION PROFILE, 
            DROP ANY SQL TRANSLATION PROFILE, ALTER ANY SQL TRANSLATION PROFILE, 
            TRANSLATE ANY SQL, 
            EXEMPT REDACTION POLICY,  
            PURGE DBA_RECYCLEBIN, LOGMINING, 
            ADMINISTER KEY MANAGEMENT
 ACTIONS    ALTER USER, CREATE ROLE, ALTER ROLE, DROP ROLE,
            SET ROLE, CREATE PROFILE, ALTER PROFILE, 
            DROP PROFILE, CREATE DATABASE LINK, 
            ALTER DATABASE LINK, DROP DATABASE LINK, 
            CREATE DIRECTORY, DROP DIRECTORY, 
            CREATE PLUGGABLE DATABASE,  
            DROP PLUGGABLE DATABASE, 
            ALTER PLUGGABLE DATABASE, 
            EXECUTE ON DBMS_RLS;

查询默认激活的审计策略只有两个ORA_SECURECONFIG和ORA_LOGON_FAILURES。

SQL> select * from AUDIT_UNIFIED_ENABLED_POLICIES;

POLICY_NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ENABLED_OPTION
------------------------------
ENTITY_NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ENTITY_TYPE    SUCCES FAILUR
-------------- ------ ------
ORA_SECURECONFIG
BY USER
ALL USERS
USER	       YES    YES


POLICY_NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ENABLED_OPTION
------------------------------
ENTITY_NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ENTITY_TYPE    SUCCES FAILUR
-------------- ------ ------
ORA_LOGON_FAILURES
BY USER
ALL USERS
USER	       NO     YES

取消此项audit

SQL>  noaudit policy ora_secureconfig;

Noaudit succeeded.

SQL> select * from AUDIT_UNIFIED_ENABLED_POLICIES;

POLICY_NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ENABLED_OPTION
------------------------------
ENTITY_NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ENTITY_TYPE    SUCCES FAILUR
-------------- ------ ------
ORA_LOGON_FAILURES
BY USER
ALL USERS
USER	       NO     YES
姚远ACE CSDN认证博客专家 ACE 华为云 MVP
Oracle ACE,华为云 MVP,Oracle10g,12c OCM; MySQL 5.6,5.7,8.0 OCP;CCNA; EMC Certified; IBM P Certified; RHCE; SQLServer 764; DB2 Certified; TOEIC 890;获得过两次国家部级科技进步奖;发明过两项计算机专利。微信:yaoyuanace 邮箱:yaoyuanace(at)qq.com
已标记关键词 清除标记
相关推荐
©️2020 CSDN 皮肤主题: Age of Ai 设计师:meimeiellie 返回首页