sa_post_login_procedure system procedure

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

Syntax
sa_post_login_procedure( )
Arguments

None

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).
Remarks

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, as well as 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.

Permissions

DBA authority required

Side effects

None

See also