1ALTER USER(7)                    SQL Commands                    ALTER USER(7)
2
3
4

NAME

6       ALTER USER - change a database role
7
8

SYNOPSIS

10       ALTER USER name [ [ WITH ] option [ ... ] ]
11
12       where option can be:
13
14             SUPERUSER | NOSUPERUSER
15           | CREATEDB | NOCREATEDB
16           | CREATEROLE | NOCREATEROLE
17           | CREATEUSER | NOCREATEUSER
18           | INHERIT | NOINHERIT
19           | LOGIN | NOLOGIN
20           | CONNECTION LIMIT connlimit
21           | [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password'
22           | VALID UNTIL 'timestamp'
23
24       ALTER USER name RENAME TO newname
25
26       ALTER USER name SET configuration_parameter { TO | = } { value | DEFAULT }
27       ALTER USER name SET configuration_parameter FROM CURRENT
28       ALTER USER name RESET configuration_parameter
29       ALTER USER name RESET ALL
30
31

DESCRIPTION

33       ALTER USER is now an alias for ALTER ROLE [alter_role(7)].
34

COMPATIBILITY

36       The  ALTER  USER  statement is a PostgreSQL extension. The SQL standard
37       leaves the definition of users to the implementation.
38

SEE ALSO

40       ALTER ROLE [alter_role(7)]
41
42
43
44SQL - Language Statements         2011-09-22                     ALTER USER(7)