You can refer to the SAP Note 2137269 – How to Use Auditing in SAP IQ 16 for further details on enabling or disabling and setting up the audit type for SAP IQ database.
Before you enable or disable the SAP IQ audit, you can use below steps to determine the current state of audit. Launch the interactive SQL, type set and press on execute. From below screenshot, you will get the current status of the audit and as example below, the audit is yet to be enable.
To Enable SAP IQ Audit
Execute below command,
set option public.auditing='On'
To Activate SAP IQ Audit Type
There are multiple audit types can be activated such as “connect”, “connectFailed”, “DDL”, “options”, “permission”, “permissionDenied”, “triggers” and “all”.
Example, if you want to activate “permission” audit type, execute below command,
sa_enable_auditing_type( 'permission')
If you want to activate all audit type, use below command
sa_enable_auditing_type( 'all')
To Disable SAP IQ Audit
To specifically disable one audit type, use below command,
sa_disable_auditing_type( 'permission')
To completely disable the audit, execute below command,
set option public.auditing='Off'
