Creating a Database User
To create a database user:
- From vsql, connect to the database as a superuser.
- Issue the
CREATE USER
statement 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
Modifying Users
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 CREATE USER
.
Example
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
, FrEd1
, fred1
, and so on.