how we can enable the audting of oracle
i want the whole schema (user level ) audting
can anybody tell me
Printable View
how we can enable the audting of oracle
i want the whole schema (user level ) audting
can anybody tell me
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.
<br>
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 [URL="http://www.oracle-base.com/articles/8i/Auditing.php"]link[/URL]