1ALTER USER(7)           PostgreSQL 9.2.24 Documentation          ALTER USER(7)
2
3
4

NAME

6       ALTER_USER - change a database role
7

SYNOPSIS

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

DESCRIPTION

32       ALTER USER is now an alias for ALTER ROLE (ALTER_ROLE(7)).
33

COMPATIBILITY

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

SEE ALSO

39       ALTER ROLE (ALTER_ROLE(7))
40
41
42
43PostgreSQL 9.2.24                 2017-11-06                     ALTER USER(7)
Impressum