DBAI_les18_Rev1_1

Views:
 
Category: Education
     
 

Presentation Description

No description available.

Comments

Presentation Transcript

Auditing : 

Auditing

Objectives : 

Objectives After completing this lesson, you should be able to do the following: Outline auditing categories Enable auditing for an instance Outline auditing options

Auditing : 

Auditing Auditing is the monitoring of selected user database actions, and is used to: Investigate suspicious database activity Gather information about specific database activities Auditing can be by session or access.

Auditing Guidelines : 

Auditing Guidelines Define what you want to audit: Users, statements, or objects Statement executions Successful statement executions, unsuccessful statement executions, or both Manage your audit trail: Monitor the growth of the audit trail. Protect the audit trail from unauthorized access.

Auditing Categories : 

Auditing Categories Audited by default Instance startup and instance shutdown Administrator privileges Database auditing Is enabled by the DBA Cannot record column values Value-based or application auditing Is implemented through code Can record column values Used to track changes to tables

Database Auditing : 

Parameter file Specify audit options Database Audit trail Audit options Enable database auditing Execute command Generate audit trail Review audit information Serverprocess OS audit trail Database Auditing

Auditing Options : 

Auditing Options Statement auditing Privilege auditing Schema object auditing AUDIT create any trigger; AUDIT TABLE; AUDIT SELECT ON emi.orders;

Auditing Options : 

Auditing Options Fine-grained auditing Provides the monitoring of data access based on content Is implemented using the DBMS_FGA package

Obtaining Auditing Information : 

Obtaining Auditing Information Information about auditing can be obtained by querying the following views: ALL_DEF_AUDIT_OPTS DBA_STMT_AUDIT_OPTS DBA_PRIV_AUDIT_OPTS DBA_OBJ_AUDIT_OPTS

Obtaining Audit Records Information : 

Obtaining Audit Records Information Information about auditing records can be obtained by querying the following views: DBA_AUDIT_TRAIL DBA_AUDIT_EXISTS DBA_AUDIT_OBJECT DBA_AUDIT_SESSION DBA_AUDIT_STATEMENT

Summary : 

Summary In this lesson, you should have learned how to: Outline auditing needs Enable and disable auditing Identify and use the various auditing options

Practice 18 Overview : 

Practice 18 Overview There is no practice for this lesson.

authorStream Live Help