Audit scenario
Auditing can help discover unwanted, unknown, and unacceptable access to the data as well as keep history records of the activities on a database system.
SECADM Pat does the following:
- Creates audit policies
- Enables audit on access to 'credit_card' table
- Enables audit on role 'custService' accessing 'credit_card' table
- Enables audit on access to the database by SYSADM and DBADM
- Archives audit logs and extracts information from the archived logs to audit tables
- Monitors audit logs for any unauthorized and unusual access