Password expiration warning [CR 420080]

The new password expiration warning feature in Sybase IQ 12.7 ESD #1 provides a simple method of notifying users when a password is about to expire. A warning message is delivered to the client application after the user successfully logs in. The new system stored procedure, sp_iq_process_post_login, and the new database option, POST_LOGIN_PROCEDURE, provide this enhancement to the current IQ Login Management facility.

Users who log in using dbisql, dbisqlc, or the Sybase Central Plug-in for Sybase IQ now see a password expiration warning, when appropriate, if Sybase IQ Login Management is enabled.

Sends a warning message to the client application for a user whose password is about to expire.

sp_iq_process_post_login

None.

If Sybase IQ Login Management is enabled and a user logs in using dbisql, dbisqlc, or the Sybase Central Plug-in for Sybase IQ, the sp_iq_process_post_login stored procedure runs immediately after a successful login. This procedure runs automatically, as the database option POST_LOGIN_PROCEDURE is set equal to sp_iq_process_post_login by default. Setting the POST_LOGIN_PROCEDURE option requires DBA authority.

The password expiration warning is sent to the client application for a user whose password expires in 10 days or less.

The password expiration warning procedure applies only to users added by the sp_iqaddlogin procedure.

After a user successfully logs in, the client application calls the stored procedure specified by the database option POST_LOGIN_PROCEDURE. The default setting of the POST_LOGIN_PROCEDURE option is DBA.sp_iq_process_post_login.

When Sybase IQ Login Management is enabled, sp_iq_process_post_login returns a password expiration warning message to the client application, if the password of the user is about to expire. When Sybase IQ Login Management is disabled, the password expiration warning is not issued.

The sp_iq_process_post_login procedure supports the client applications dbisql, dbisqlc, and the IQ plug-in for Sybase Central. dbisql, dbisqlc, and the IQ plug-in for Sybase Central display the warning “Your password will expire in n days! Please change your password as soon as possible.” In addition, dbisql and the IQ plug-in for Sybase Central also display a Reset Password dialog with the warning message, a request that the user change the password, and text boxes to supply and confirm a new password.

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

String

DBA.sp_iq_process_post_login

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

The default post login procedure, sp_iq_process_post_login, 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 sp_iq_process_post_login. 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.