Controls whether auditing is enabled or disabled for each connection when the auditing option is set to On.

Allowed values

On, Off

Default

On

Scope

Can be set as a temporary option only, for the duration of the current connection. DBA authority required.

Remarks

The setting of the conn_auditing option is only respected when it is set in a login procedure (specified by the login_procedure database option). Setting conn_auditing to On turns on auditing for the connection. However, auditing information is not recorded unless the auditing option is also set to On. You can execute the following statement to determine whether a connection is being audited:

SELECT CONNECTION_PROPERTY ( 'conn_auditing' );

See also

• Controlling auditing
• auditing option [database]
• login_procedure option [database]