Oracle Database auditing is which in it completely enables the selective and effective auditing of the database and it’s certain policies and conditions thus simplifying the management of auditing within the database by providing the ability for accelerating auditing based on the conditions.

Database auditing is basically a facility which can track the usage of database resources and authority. The operation produces an audit trail  which includes the information such as how the database object was impacted. The audit trail of database operations produced can be maintained over time to allow DBAs and auditors, as well as any authorized personnel.
Statement Auditing
In this statement Audit table tracks several DDL statements regardless of the table on which they are issued. One can get the statement auditing to audit the selected users for every user in the database.
Privilege Auditing
Privilege auditing is more focused on the statement auditing. Auditing only use the target privilege. One can set the  privilege auditing to audit a selected user or every user in the database.
Object Auditing
The selective auditing of the specific statements  is mainly depended on a particular schema object, such as AUDIT SELECT ON EMP. Object auditing always applies to all users of the database.
Focus of Auditing
This follows audit options which are to be focused in the following areas:
  • Audit with successful statement executions, unsuccessful statement executions, or both for checking
  • Audit statement executions which is known to be executed once per user session or once every time the statement is executed
  • Audit activities of all users or of a specific user
This guards  and records the database actions from the database users and non database thus ensuring database security.An administrator can perform auditing such Structured Query Language (SQL) statement on the individual actions.. Auditors audit both successful and failed activities, including or excluding specific users from the audit

Thus database  is safeguarded and this includes all database features such as installation, default account, patches, services, password policy, account lockout policy and audit policy. Audit process is known to be a continuous process.
In database auditing these are the major risks:
  • Mistake: Failure to operate the database which is accidental disclosure of information, changes which are unauthorized leading inserts, updates or deletions accidentally.
  • Misuse: Failure for accessing the  rights to the database which may cause privileged access and leakage of information.
  • Malicious action: Failure for maintaining a secure, logical setup of the database thus causing data theft.
The quality of our services is guaranteed