CREATE USER v16
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;