Category: IQ: System Functions: Auditing

sa_disable_auditing_type

sa_disable_auditing_type is a system procedure of IQ. It deactivates auditing for one, several or all audit events or categories. sa_disable_auditing_type can only be executed with DBA privileges. The parameter string is of the datatype varchar(128) and must be set in single quotes.

sa_disable_auditing_type: syntax

    sa_disable_auditing_type('string')
    

The Parameter of the System Procedure sa_disable_auditing_type

"string"
The parameter "string" is a comma separated string of characters. It can contain one or more values. Possible values are:
all - deactivates all audit events or categories.
connect - deactivates auditing for connection attempts, whether successful or not.
connectFailed - deactivates auditing for failed connection attempts.
DDL - deactivates auditing of DDL statements.
options - deactivates auditing of so-called "public" options.
permission - deactivates auditing for checks on permission level and user level and on SETUSER commands.
permissionDenied - deactivates auditing of failed checks on permission and user level.
triggers - deactivates auditing of trigger events.

The system procedure is executed with the CALL statement.

    CALL sa_disable_auditing_type('all')
    

Deactivates all auditing events.

    CALL sa_disable_auditing_type('connect')
    

Deactivates the auditing category 'connect'.

    CALL sa_disable_auditing_type('connect, DDL, triggers')
    

Deactivates the auditing categories 'connect', 'DDL' and 'triggers'.