Set_password

sql

FUNCTION Set_password(IN username CHAR(31), IN password CHAR(100)) RETURNS BIT;

Parameters

username name of the user
password password

Description

This function sets a new password to the specified user. The password length is 100 character max.

You may not change the anonymous user password.

Each user may use this function on its own password. Only the security administrator may change password of another user.

Function value

This function returns FALSE if successful, TRUE otherwise.