|
 |
|
| |
NameCREATE 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. Use NOCREATEDB to explicitly deny that permission (which is the default).
-
CREATEUSER | NOCREATEUSER
-
The superuser privilege. The use of CREATEUSER allows access to both the CREATE USER and DROP 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
Use CREATE USER to add new users to a PostgreSQL database. This command is only usable by database superusers. For more information about managing users and authentication, refer to Chapter 10.
Note: You may also use the
createuser
script to add users to a database from the operating system command line. Use of the script is essentially as using this command.
Example
The following example demonstrates how to create a PostgreSQL user (david) in the accounting group that is valid until January 1, 2005 and has the specified password of
jw8s0F4.
booktown=#
CREATE USER david
booktown-#
WITH PASSWORD 'jw8s0F4' CREATEDB
booktown-#
IN GROUP accounting VALID UNTIL 'Jan 1 2005';
CREATE USER
|
|
|
