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
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.
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 StartedRecommended Textbook for
Accounting Information Systems
Authors: George H. Bodnar, William S. Hopwood
11th Edition
0132871939, 978-0132871938
Students also viewed these Databases questions
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
View Answer in SolutionInn App