Specify BY SESSION if you want Oracle Database to write a single record for all SQL statements of the same type issued and operations of the same type executed on the same schema objects in the same session. See Also: Oracle Database Security Guide for information on network auditing You can change the auditing options for an existing object only by specifying the object in the ON clause of the AUDIT statement. When you change the default auditing options, the auditing options for previously created objects remain the same. You can see the current default auditing options by querying the ALL_DEF_AUDIT_OPTS data dictionary view. The default auditing options for a view are always the union of the auditing options for the base tables of the view. After you have established these default auditing options, any subsequently created object is automatically audited with those options. ON DEFAULT Specify ON DEFAULT to establish the specified object options as default object options for subsequently created objects. You can also specify a synonym for a table, view, sequence, procedure, stored function, package, materialized view, or user-defined type. The object must be a table, view, sequence, stored procedure, function, package, materialized view, or library. ObjectSpecify the name of the object to be audited. If you omit schema, then Oracle Database assumes the object is in your own schema. SchemaSpecify the schema containing the object chosen for auditing. See Also: 'Auditing Queries on a Table: Example', 'Auditing Inserts and Updates on a Table: Example', and 'Auditing Operations on a Sequence: Example' You can review database activity by examining the audit trail through data dictionary views. Oracle Database writes audit records to the audit trail, which is a database table containing audit records. Specify a statement option to audit specific SQL statements.įor each audited operation, Oracle Database produces an audit record containing this information: Use the sql_statement_clause to audit SQL statements. See Also: Oracle Database Reference for information on the AUDIT_TRAIL parameterĭescription of the illustration audit.gifĭescription of the illustration sql_statement_clause.gifĭescription of the illustration auditing_by_clause.gifĭescription of the illustration schema_object_clause.gifĭescription of the illustration auditing_on_clause.gif

Observation synonym