Description

Part B Lab Auditing includes phase 1 and phase 2.

The task is to design and implement the following auditing functions on the CUSTOMER table.

  • Track all “SELECT” activities on the CUSTOMER table, including database user, operating system user, and time when the operation is performed.
  • Track the changes when CREDIT_LIMIT is set to a value above $5,000.
  • Track the CUSTOMER table when a customer record was deleted.