|
Controls whether auditing is enabled or disabled for each connection when the auditing option is set to On.
On, Off
On
| PUBLIC role | For current user | For other users | |
|---|---|---|---|
| Allowed to set permanently? | No | No | No |
| Allowed to set temporarily? | Yes with SET ANY SECURITY OPTION | Yes (current connection only) | No |
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' );