Category: IQ: Databaseoptions

AUDITING option

The AUDITING option is a database option of IQ. With the help of the SET OPTION statement, auditing in a database can be activated ('ON') or deactivated ('OFF'). In order for the auditing functions of IQ to work, the AUDITING option must be set to 'ON'. If AUDITING was activated with 'ON', but no auditing options were defined, the every possible option is being audited and the information written to the transaction log. The system procedure sa_enable_auditing_type can be used to define which categories to audit. sa_disable_auditing_type can be used to exclude certain categories from auditing.

The AUDITING option can only be executed with DBA privileges and can only be activated for the group PUBLIC. Auditing will start with execution of the set command.

AUDITING option: syntax

    SET OPTION PUBLIC.AUDITING = '[ON|OFF]'
    

The Parameters of the Database Option AUDITING

'ON'
Switches auditing on for a databases; activates auditing.

'OFF'
Switches auditing for a database off; deactivates auditing.

AUDITING-Option: Example

    SET OPTION PUBLIC.AUDITING = 'ON'