POST_LOGIN_PROCEDURE option

Function

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 dbisql, dbisqlc, and the IQ plug-in for Sybase Central.

See also

“LOGIN_PROCEDURE option”

“Managing IQ user accounts and connections” in Chapter 8, “Managing User IDs and Permissions” in the System Administration Guide: Volume 1