Note: Documentation for Pivotal SQLFire 1.1.x is now available at http://docs.gopivotal.com/sqlfire/index.html. Please reference the docs.gopivotal.com site for the latest and most up-to-date documentation on SQLFire. The vFabric SQLFire documentation site will no longer be updated.

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.