Consider the following security trigger

$--$ Table for logging delete attempts

CREATE TABLE audit$\_$log $($

event$\_$id SERIAL PRIMARY KEY,

event$\_$time TIMESTAMP NOT NULL,

username TEXT NOT NULL,

table$\_$name TEXT NOT NULL,

action$\_$taken TEXT NOT NULL

;

$--$ Trigger function to log delete attempts

CREATE OR REPLACE FUNCTION log$\_$delete$\_$attempt $()$

RETURNS TRIGGER AS $$

BEGIN

INSERT INTO audit$\_$log$($event$\_$time, username, table$\_$name, action$\_$taken$)$

VALUES $($now $(),$ CURRENT$\_$USER, TG$\_$TABLE$\_$NAME, 'DELETE ATTEMPT'$)$;

RETURN OLD;

END;

$$ LANGUAGE plpgsql;

$--$ Trigger for delete attempts on sensitive table 'customer$\_$data'

CREATE TRIGGER trigger$\_$log$\_$delete

BEFORE DELETE ON customer$\_$data

FOR EACH ROW EXECUTE FUNCTION log$\_$delete$\_$attempt$()$;

What does the audit$\_$log table store?

Every login attempt by a user

Attempts to delete rows from the customer$\_$data table

Every change to the database schema

All the INSERT operations in the database