SYS.CHANGE_PASSWORD

Changes the password of an existing BUILTIN user.

Syntax

SYS.CHANGE_PASSWORD (
IN USER_ID VARCHAR(128)
IN OLDPASSWORD VARCHAR(128)
IN NEWPASSWORD VARCHAR(128)
)
USER_ID
The name of the existing user. See SYS.SHOW_USERS.
OLDPASSWORD
The existing password of the specified USER_ID, or a null or empty string for the old password (if an Admin user is changing the password of another user).
A user can change their own password by providing the correct, old password. Admin users can change any password by providing null or an empty string for the old password. If a non-empty value is provided, then it must match the old password.
The ability to change other users' passwords is enabled for the database owner by default. Other users can be explicitly GRANTed EXECUTE permission on the procedure. However, this works only when sqlfire.sql-authorization is true. Otherwise, any user can change another user's password by providing the correct old password of that user. When sqlfire.sql-authorization is false, then even the database owner has to provide the correct, old password.
NEWPASSWORD
The new password to assign to the user.

Example

Change the password of a specified user:
sqlf> call sys.change_password('SIMON','oldpasword','newpassword');
Statement executed.
Change the password of a specified user, using a database owner account (and sqlfire.sql-authorization enabled):
sqlf> call sys.change_password('SIMON',null,'newpassword');
Statement executed.