GeekInterview.com
Series: Subject: Topic:
Question: 23 of 32

What is Privilege Auditing ?

Privilege auditing is the auditing of the use of powerful system privileges without regard to specifically named objects.
Asked by: Interview Candidate | Asked on: Sep 6th, 2004
Showing Answers 1 - 1 of 1 Answers

Privilege auditing involves the tracking of the SQL statements issued by users who have been granted the right to execute that statement through a system privilege. In order to enable or disable auditing on SQL statements, you must have the AUDIT SYSTEM privilege. Privilege audit options match the corresponding system privileges. For example, in order to audit the DELETE ANY TABLE system privilege, you would issue the following command: AUDIT DELETE ANY TABLE BY ACCESS WHENEVER SUCCESSFUL.  (Ref: Burlson)

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.