Question
Provide the SQL code/statements Create a table with two columns. You have to audit all SQLstatements on your table. To do this you will write
Provide the SQL code/statements
Create a table with two columns.
You have to audit all SQLstatements on your table. To do this you will write two triggers: 1. To log any SQLstatements that users might run on this table. The results must be stored in the First Initial _ Last Name _ Log table. The table should have unique event ID, values for both the Oracle and the system user who ran the query, the time it was executed and the type of SQL query user ran.
2. To capture any data that was changed in the table. The results must be stored in the First Initial _ Last Name _ History table The table should reference the event ID from the log table, and store both old and new values for both columns.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started