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

SELECT CONNECTION_PROPERTY ( 'conn_auditing' );

conn_auditing option

Allowed values

Default

Scope

Remarks

See also