1.1.1

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.
SYS.CREATE_USER
Adds a new BUILTIN user account to the SQLFire distributed system.
Syntax
SYS.CREATE_USER (
IN USER_ID VARCHAR(128)
IN PASSWORD VARCHAR(128)
)
USER_ID
The name of the user to create. Note that SQLFire stores normalized (all upper-case) user
names, so "User1" and "user1" refer to the same BUILTIN user. See also SYS.SHOW_USERS
on page 622.
NEWPASSWORD
The new password to assign to the user. See also SYS.CHANGE_PASSWORD on page 618.
Example
Create a new BUILTIN user:
sqlf> call sys.create_user('SIMON','apassword');
Statement executed.
SYS.DISKSTORE_FSYNC
Flush and fsync all data to configured disk stores, including data in asynchronous persistence queues.
Use this procedure to ensure that all in-memory data is written to configured disk stores. You may want to fsync
data in disk stores before copying or backing up disk store files at the operating system level, to ensure that they
represent the current state of the SQLFire data.
619
SQL Language Reference