Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Information Systems

Authors: George H. Bodnar, William S. Hopwood

11th Edition

0132871939, 978-0132871938

More Books

Students also viewed these Databases questions