Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » SQL Anywhere Server - SQL Reference » System Objects » System procedures » Alphabetical list of system procedures


sa_post_login_procedure system procedure

Determines whether a user's password is about to expire.

sa_post_login_procedure( )


Result set

The sa_post_login_procedure system procedure returns the following:

Column name Data type Description
message_text VARCHAR(255) If message_action is 1, message_text returns the message to display. If message_action is 0, message_text is NULL.
message_action INTEGER Whether the password is about to expire (1=yes, 0=no).

The sa_post_login_procedure system procedure is the default setting for the post_login_procedure database option. See post_login_procedure option [database].

sa_post_login_procedure uses the user's password_life_time and password_grace_time login policy option values, and the current date and time, to determine whether a user's password is about to expire. If it is, the message to display to the user is returned in the result set.


DBA authority required

Side effects


See also