CREATE USER v16
CREATE USER — Define a new database user account.
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.
The name of the user.
The user’s password. You can change the password later using
The maximum length allowed for the user name and password is 63 characters.
Create a user named