Creating a Database User
To create a database user:
- From vsql, connect to the database as a superuser.
- Issue the
CREATE USERstatement with optional parameters.
- Run a series of GRANT Statements to grant the new user privileges.
To create a user on MC, see Creating an MC User in Management Console
New User Privileges
By default, new database users have the right to create temporary tables in the database.
Newly-created users do not have access to schema
PUBLIC by default. Make sure to
GRANT USAGE ON SCHEMA PUBLIC to all users you create
You can change information about a user, such as his or her password, by using the
ALTER USER statement. If you want to configure a user to not have any password authentication, you can set the empty password ‘’ in
CREATE USER or
ALTER USER statements, or omit the
IDENTIFIED BY parameter in
The following series of commands add user Fred to a database with password 'password. The second command grants USAGE privileges to Fred on the public schema:
=> CREATE USER Fred IDENTIFIED BY 'password'; => GRANT USAGE ON SCHEMA PUBLIC to Fred;
User names created with double-quotes are case sensitive. For example:
=> CREATE USER "FrEd1";
In the above example, the logon name must be an exact match. If the user name was created without double-quotes (for example,
FRED1), then the user can log on as
fred1, and so on.