Skip to content

Latest commit

 

History

History
14 lines (10 loc) · 569 Bytes

README.md

File metadata and controls

14 lines (10 loc) · 569 Bytes
Raw

oracleDB

Standard Audit

  1. SHOW PARAMETER AUDIT
  2. ALTER SYSTEM SET audit_trail=db SCOPE=SPFILE

AUDIT_TRAIL = { none | os | db | db,extended | xml | xml,extended }

  • none or false - Auditing is disabled.
  • db or true - Auditing is enabled, with all audit records stored in the database audit trial (SYS.AUD$).
  • db,extended - As db, but the SQL_BIND and SQL_TEXT columns are also populated.
  • xml- Auditing is enabled, with all audit records stored as XML format OS files.
  • xml,extended - As xml, but the SQL_BIND and SQL_TEXT columns are also populated.