Monitoring of user access to aid in the investigation of database use.
Latest Answer : Auditing involves in recording all the activities based on the auditing rulesSome types of auditing are Database level Auditing, Schema Level auditing, Object level Auditing and Statement level auditing. ...
Statement Auditing, Privilege Auditing and Object Auditing.
Statement auditing is the auditing of the powerful system privileges without regard to specifically named objects.
Latest Answer : The Statement auditing is tracking the SQL statements issued by database users. In order to enable or disable auditing on SQL statements, you must have the AUDIT SYSTEM privilege. ...
Privilege auditing is the auditing of the use of powerful system privileges without regard to specifically named objects.
Latest Answer : 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 ...
Object auditing is the auditing of accesses to specific schema objects without regard to user.
Latest Answer : Object auditing involves the tracking of the specific SQL DML statements issued against objects by database users. ...
