CREATE USER v15

Name

CREATE USER  Define a new database user account.

Synopsis

CREATE USER <name> [IDENTIFIED BY <password>]

Description

CREATE USER adds a user to an EDB Postgres Advanced Server database cluster. You must be a database superuser to use this command.

When you invoke the CREATE USER command, a schema is created with the same name as the new user. The new schema is owned by the new user. Objects with unqualified names that this user creates are created in this schema.

Parameters

name

The name of the user.

password

The user’s password. You can change the password later using ALTER USER.

Notes

The maximum length allowed for the user name and password is 63 characters.

Examples

Create a user named john:

CREATE USER john IDENTIFIED BY abc;

See also

DROP USER