Starting with Sclera 2.2, the Sclera platform maintains user accounts and passwords.

When installed, only one account exists – that of the licensed user, with the user id as the email address registered at the Sclera website.

Password Management for the Licensed User

The licensed user is the administrator. Only this user can create and remove new users, as described in the next section.

When installed, the licensed user has no password. If you plan to start a ODBC/JDBC server and allow external connections, it is highly recommended that you set a password for the licensed user.

The password can be set using the Sclera shell. The shell is started by executing the script $SCLERA_HOME/bin/sclera.sh, where $SCLERA_HOME is the directory where Sclera is installed.

The following shell command sets the password of the licensed user to mysecret:

> SET PASSWORD "mysecret";

After the password is set, you need to enter the licensed user’s id and password to start the shell next time.

$ $SCLERA_HOME/bin/sclera.sh -u "sclerauser@example.com" -p "mysecret"

If you do not want to openly state the password, say -p "?" instead and the shell will present a password prompt.

$ $SCLERA_HOME/bin/sclera.sh -u "sclerauser@example.com" -p "?"
Password: ******

You can remove an already set password in the Sclera shell:

> REMOVE PASSWORD;

Adding and Removing Additional Users

The shell considers the licensed user as the administrator. This user alone can add and remove users.

The following Sclera shell command adds a user scott with password tiger,

> ADD USER scott PASSWORD "tiger"

The added user can connect through ODBC / JDBC / psql using the above credentials.

The users can be removed by the the licensed user:

> REMOVE USER scott;

Related Documentation