What is Auditing? What are the different Levels of Auditing?Auditing includes reading, writing and deleting the access on the objects at the table level. The privileges granted to a user can be audited. Auditing stores the tracking of events.
There are three levels of auditing:
Statement Level:- Statement level auditing is tracking of sql statements.
Privilege level:- Privilege level auditing is tracking of sql statements of privileged users who have been granted the rights to execute the statement.
Object level:- Object level auditing is used to audit specific schema objects irrespective of user.