Category: IQ: System Procedures: Auditing

sa_enable_auditing_type

sa_enable_auditing_type is a system procedure of IQ. It activates auditing for one, several or all audit events or audit categories. sa_enable_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_enable_auditing_type: syntax

    sa_enable_auditing_type('string')
    

The Parameter of the System Procedure sa_enable_auditing_type

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

The system procedure is executed using the CALL statement.

    CALL sa_enable_auditing_type('all')
    

Activates all auditing events.

    CALL sa_enable_auditing_type('connect')
    

Activates the auditing category 'connect'.

    CALL sa_enable_auditing_type('connect, DDL, triggers')
    

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