As a DBA, you received an approved change request to implement a solution to prevent the two
Question:
As a DBA, you received an approved change request to implement a solution to prevent the two users (WLISA and DBSEC_CLERK) from update or delete customers table. You are also going to audit the update and delete activities of these two users.
Specifically, you need to:
1. Create trigger. The trigger will not allow these two users (WLISA or DBSEC_CLERK) to update or delete customers table.
2. Raise an error message whenever the above two users attempt to update or delete records in customers table. The message will read
"You do not have the privilege update or delete the customers table. Please contact your manager if you need the privilege."
3. Use one statement of your choice to test your trigger on each user on delete statement, respectively.
4. Show the audit records of the above attempts including operating system user name, database user name, date and action name. Please explain how you can audit the select on a table.
Please choose any of the auditing model that you think is proper.
Accounting Information Systems
ISBN: 9780132871938
11th Edition
Authors: George H. Bodnar, William S. Hopwood