Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Controls whether auditing is enabled or disabled for each connection when the auditing option is set to On.
Can be set as a temporary option only, for the duration of the current connection. DBA permissions are required to set this option.
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' );