One of Oracle security product called Audit Vault. Audit Vault gathers auditing information from databases and store them in a centralized database. It can help customers to comply with SOX and other regulations. It can help in proactive monitoring and to mitigate security risks.
Audit Vault and Database Vault are Oracle Security products. DBV control the access to your information while AV let you build a data warehouse to run reports
With AVDF you can view any data audited in the database such as privileges and stored procedures,which enables auditors to track the use of, and changes to, procedures by applications as well as their users.
The Stored Procedure Audit Reports provide a listing of how the stored procedures have been modified, when stored procedures are created or deleted, and other related activity
It can be help full in diagnosing performance issue where people say no change was done in code. which is sometimes difficult for DBA's to find
Below are the steps involved in installing AV Server.
Audit Vault Server and Database Firewall should be installed on its own dedicated x86 64-bit server (or Oracle VM 3.x). Or Oracle Linux, Release 5 Update 10 compatible hardware.You do not need administrative privileges for installation.
The installation passphrase must have between 8 to 255 characters in these categories:
>Uppercase letters (A-Z) - must have at least one
>Lowercase letters (a-z) - must have at least one
>Digits (0-9) - must have at least one
>At least one of the following:
–Comma (,)
–Period (.)
–Colon (:)
–Plus sign (+)
–Underscore (_)
> Space [you can but it should be avoided]
