What is Auditing? What are the different Levels of Auditing?

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.
Explain Statement Auditing, Privilege Auditing, And Object Auditing
There are three levels of auditing: Statement level: Statements found in stmt_audit_option_map are audited.....
What are the steps to creating a password authentication file?
The steps are : First set REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE in init.ora file, Then dbs$orapwd file=orapw$ORACLE_SID password=sys force=y.....
What is configure command and recovery catalog?
Cold Backup, Physical Backup, Logical Backup, Hot backupA recovery catalog is a schema stored in a database. It tracks backups and stores scripts for use in RMAN backup and recovery situations...
Post your comment