Explain Statement Auditing, Privilege Auditing, And Object Auditing

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.

Object level: objects like tables, views, sequences, packages, stored procedures, stored functions are sudited.

Privilege level: All system privileges that are found in system_privilege_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...
What are different types of backup? (Hot, Cold, logical, Physical)?
Cold Backup, Physical Backup, Logical Backup, Hot backup...
Post your comment