Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Sql statments Exercise 1. Enable the standard audit trial. 2. Don't do any audit to current session user Jaafer 3. Do audit for unsuccessful DMLSTATEMENTS.

Sql statments image text in transcribed
Exercise 1. Enable the standard audit trial. 2. Don't do any audit to current session user Jaafer 3. Do audit for unsuccessful DMLSTATEMENTS. 4. Audit INSERT, DELETE privileges a in new object which will create in future 5. Remove audit from user laafer who created procedures. 6. Do audit for Select, insert a table of user Lakshmi. 7. Audit entire statement in the current session of all users. 8. Remove all privileges in auditing. 9. Don't do any audit for Hr. employees table. 10. Audit all the update on future table. Exercise 11. Create view "empview" using hremployees table, do audit using select privilege on empview. 12. Write a Fine grained audit policy "project_fgapolicy" which will either audit User_id column or No_of_hours column. Display statement type, object information of the project_fgspolicy. Login Arvind display the project table. Display the fine grain audit records of project table and remove the audit information. Prat. Jealer Al Somoireh - Filicess Sumaya Ualvanily for Techndedy

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

Database Concepts

Authors: David M Kroenke, David J Auer

6th Edition

0132742926, 978-0132742924

More Books

Students also viewed these Databases questions

Question

=+What needs to be said first?

Answered: 1 week ago