What is Privilege Auditing ?

Privilege auditing is the auditing of the use of powerful system privileges without regard to specifically named objects.

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)

  Was this answer useful?  Yes

Give your answer:

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

 

Related Answered Questions

 

Related Open Questions