Implementing Auditing
By default, auditing is disabled when the database is started up. You have to activate it by following these steps:
Enable auditing at the database level with the INIT.ORA parameter AUDIT_TRAIL.
Enable the level of auditing through the AUDIT SQL statement.
The AUDIT_TRAIL parameter must be enabled for auditing to work. The valid values for this parameter are DB, NONE, and OS:
- DB
Enables auditing to the internal data dictionary
- NONE
Disables all auditing
- OS
Enables auditing to the operating system audit trail
This parameter is highly platform dependent. Consult your platform’s installation guide to determine if it is enabled for your configuration. Please refer to Chapter 12, for more information about setting INIT.ORA parameters.
Get Oracle Database Administration: The Essential Refe now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
