Creating Users and Logging In

When a database is created there are two users created by default. The default users are PUBLIC and _SYSTEM. PUBLIC has the minimal permissions possible in TEXIS, and _SYSTEM has the maximum permissions in TEXIS. When these are created they are created without any password. You should change the password on _SYSTEM to prevent security issues. The password on PUBLIC can be left blank to allow anonymous access to the database, or it can be set to restrict access.

When logging into TEXIS the username will default to PUBLIC if none is specified. This means that tables will be created owned by PUBLIC, and all users will have permissions to use the tables. It is possible to use only the PUBLIC user while developing a database, although if multiple people are working on the database you should see the previous comments about operating system permissions.

To create new users in the database you must may either use the program tsql -a a, and you will be prompted for the user's information, or you can user the CREATE USER SQL statement. You must log in as _SYSTEM to add or delete users.

The syntax for the user administration command in SQL are as follows:

CREATE USER username IDENTIFIED BY password ;

ALTER  USER username IDENTIFIED BY password ;

DROP   USER username ;

You may issue the ALTER USER command if you are logged in as the same user that is given in the statement, or if you are _SYSTEM. The password should be given as a string in single quotes. The ALTER USER statement is used to change a users password, the new password being specified in the command. Dropping a user will not remove any tables owned by that user.