Setup audit policies



You must log into the database as Pat before proceeding with this page.

The 'credit_card' table is accessed by different users for different purpose. SECADM Pat wants to audit the employees, managers, and administrators for any activities on that table.

Operation


Auditing can be enabled on different objects like tables, roles, trusted context objects, authorities (SYSADM, DBADM, SECADM) and database.

Pat would like to audit the 'credit_card' table, 'custService' role, SYSADM and DBADM authorities. Based on this requirement, he performs the following:


Solution


All required audit policies are now set.