conn_auditing option

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

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. To determine whether a connection is being audited, execute the following statement:

SELECT CONNECTION_PROPERTY ( 'conn_auditing' );

conn_auditing option

Allowed values

Default

Scope

Remarks

See also