POST_LOGIN_PROCEDURE Option

Specifies a login procedure whose result set contains messages that are displayed by the client application immediately after a user successfully logs in.

Allowed Values

String

Default

dbo.sa_post_login_procedure

Scope

Can be set for an individual connection or the PUBLIC group. DBA permissions required to set this option. Takes effect immediately.

Description

The default post login procedure, dbo.sa_post_login_procedure, executes immediately after a user successfully logs in.

If you have DBA authority, you can customize the post login actions by creating a new procedure and setting POST_LOGIN_PROCEDURE to call the new procedure. Do not edit dbo.sa_post_login_procedure. The customized post login procedure must be created in every database you use.

The post login procedure supports the client applications Interactive SQL, Interactive SQL Classic, and the IQ plug-in for Sybase Central.

Related reference
LOGIN_PROCEDURE Option