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.
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 following shell command sets the password of the licensed user to
> 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 "firstname.lastname@example.org" -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 "email@example.com" -p "?" Password: ******
You can remove an already set password in the Sclera shell:
> REMOVE PASSWORD;
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
> 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;