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