oracle auditing

[pande.dhiraj]

how we can enable the audting of oracle
i want the whole schema (user level ) audting

can anybody tell me

[susarlasireesha]

Auditing can be disabled (audit_trail=false), or enabled. If auditing is enabled, the audit information can either go to a table in the database or to the operating system trail. This can be determined by audit_trail.


Possible levels of auditing :There are three levels that can be audited:
1.Statement level
Statements that can be audited are found in stmt_audit_option_map
2.Object level
These objects can be audited: tables, views, sequences, packages, stored procedures, stored functions.
3.Privilege level
All system privileges that are found in system_privilege_map.
For more information see this link