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.
NEWPASSWORD
The new password to assign to the user. See also SYS.CHANGE_PASSWORD.

Example

Create a new BUILTIN user:
sqlf> call sys.create_user('SIMON','apassword');
Statement executed.