Create User
Creates a new PostgreSQL database user.
Synopsis
CREATE USER username [ WITH [ SYSID uid ] [ PASSWORD 'password' ] ] [ CREATEDB | NOCREATEDB ] [ CREATEUSER | NOCREATEUSER ] [ IN GROUP groupname [, ...] ] [ VALID UNTIL 'abstime' ]
Parameters
username
The name of the new user you intend to create.
uid
The explicit user ID for the PostgreSQL user that you are creating; if left out of the
CREATE USER
command, the user ID will be automatically assigned.password
The new PostgreSQL userâs password; if the database is setup to require password authentication, this must be set for the user to be able to connect. Otherwise, a defined password is not meaningful to PostgreSQL.
CREATEDB | NOCREATEDB
The privilege to create new databases. Use
CREATEDB
, to give the user permission to create databases. UseNOCREATEDB
to explicitly deny that permission (which is the default).CREATEUSER | NOCREATEUSER
The superuser privilege. The use of
CREATEUSER
allows access to both theCREATE USER
andDROP USER
commands, as well as makes the user a superuser (with universal rights across all databases).NOCREATEUSER
is the default.groupname
The optional name of a group to which the user is to automatically be added.
abstime
The timestamp that defines when a userâs password expires. When the date and time that
abstime
defines has been reached, the userâs defined password becomes invalid. If unset, the password never expires.
Results
CREATE USER
The message returned when a user is created successfully.
Description ...
Get Practical PostgreSQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.