LOG_CONNECT Option

Controls logging of user connections.

Allowed Values

ON, OFF

Default

Scope

Option can be set at the database (PUBLIC) level only.

Requires the SET ANY SECURITY OPTION system privilege to set this option. Takes effect immediately.

Remarks

When this option is ON, a message appears in the IQ message log (.iqmsg file) every time a user connects to or disconnects from the SAP Sybase IQ database.

Note: If this option is set OFF (connection logging disabled) when a user connects, and then turned on before the user disconnects, the message log shows that user disconnecting but not connecting.