First, let’s create our own audit log table to track the info about the host and time of the attempt: Then create the trigger: Now,…
1> Show the enabled policies: 2> Flush the Audit Trail: 3> Clean the Audit Trail: Note: This might get an error -> ORA-00054: resource busy…