Determines whether a user's password is about to expire.
sa_post_login_procedure( )
None
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
None
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |