sa_post_login_procedure system procedure

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.

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

None

sa_post_login_procedure system procedure

Syntax

Arguments

Result set

Remarks

Permissions

Side effects

See also