Document TypeㅣTechnical Information
CategoryㅣMonitoring/Inspection
Document NumberㅣTMOTI037
Overview
Tibero DBMS Audit Parameters control settings such as the storage location, size, and method of audit records. They can be temporarily changed dynamically using the ALTER SYSTEM statement, but since they reset to default values upon restart, it is recommended to add parameters to the TIP file for permanent application.
This document introduces the types of Tibero DBMS Audit parameters.
- AUDIT_FILE_DEST
- AUDIT_FILE_SIZE
- AUDIT_SYS_OPERATIONS
- AUDIT_TRAIL
Method
AUDIT_FILE_DEST
Parameter that sets the directory path where audit files are stored; it must be written as an absolute path.
Category | Description |
|---|---|
Type | String |
Default Value | $TB_HOME/instance/$TB_SID/audit |
Attributes | Optional, Adjustable, Dynamic, System |
Setting Method | Set in the TIP file and restart or change with an ALTER statement. |
- TIP file usage syntax
AUDIT_FILE_DEST=/home/tibero/audit
- ALTER statement usage syntax
ALTER SYSTEM SET AUDIT_FILE_DEST=/home/tibero/audit ALTER SESSION SET AUDIT_FILE_DEST=/home/tibero/audit
AUDIT_FILE_SIZE
Parameter that sets the maximum size of the audit.log file.
When a single audit.log file exceeds the value defined by the AUDIT_FILE_SIZE parameter, a new audit.log file is created.
Category | Description |
|---|---|
Type | Integer |
Default Value | 104857600 |
Attributes | Optional, Adjustable, Static, System |
Setting Method | Set in the TIP file and restart. |
- TIP file usage syntax
AUDIT_FILE_SIZE = 10M
AUDIT_SYS_OPERATIONS
Parameter that sets whether auditing is performed for the SYS user.
Category | Description |
|---|---|
Type | Boolean |
Default Value | N |
Attributes | Optional, Adjustable, Dynamic, System |
Setting Method | Set in the TIP file and restart or change with an ALTER statement. |
- TIP file usage syntax
AUDIT_SYS_OPERATIONS = {Y|N}
- ALTER statement usage syntax
ALTER SYSTEM SET AUDIT_SYS_OPERATIONS = {Y|N}
ALTER SESSION SET AUDIT_SYS_OPERATIONS = {Y|N}
AUDIT_TRAIL
Parameter that specifies the audit method when enabling audit functionality.
Category | Description |
|---|---|
Type | String |
Default Value | NONE |
Range | NONE | OS | DB | DB_EXTENDED - NONE : No audit records are saved even if auditing is performed - OS : Audit records are saved as OS files - DB : Audit records are saved inside the database - DB_EXTENDED : In addition to basic information included in audit records, SQL statements (SQL TEXT) executed by users are also saved in the database ※ OS : Audit records are in log file format ※ DB/DB_EXTENDED : Audit records are in the SYS_DD_AUD table, and information is provided via the user_audit_trail View or dba_audit_trail View |
Attributes | Optional, Adjustable, Dynamic, System |
Setting Method | Set in the TIP file and restart or change with an ALTER statement. |
- TIP file usage syntax
AUDIT_TRAIL = DB
- ALTER statement usage syntax
ALTER SYSTEM SET AUDIT_TRAIL = DB ALTER SESSION SET AUDIT_TRAIL = DB