This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the
current
version, or one of the other supported versions listed above instead.
ALTER USER
Name
ALTER USER -- change a database role
Synopsis
ALTER USER name [ [ WITH ] option [ ... ] ]
where option can be:
SUPERUSER | NOSUPERUSER
| CREATEDB | NOCREATEDB
| CREATEROLE | NOCREATEROLE
| CREATEUSER | NOCREATEUSER
| INHERIT | NOINHERIT
| LOGIN | NOLOGIN
| REPLICATION | NOREPLICATION
| CONNECTION LIMIT connlimit
| [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password'
| VALID UNTIL 'timestamp'
ALTER USER name RENAME TO new_name
ALTER USER name [ IN DATABASE database_name ] SET configuration_parameter { TO | = } { value | DEFAULT }
ALTER USER name [ IN DATABASE database_name ] SET configuration_parameter FROM CURRENT
ALTER USER name [ IN DATABASE database_name ] RESET configuration_parameter
ALTER USER name [ IN DATABASE database_name ] RESET ALL
Description
ALTER USER is now an alias for
ALTER ROLE.
Compatibility
The ALTER USER statement is a
PostgreSQL extension. The SQL
standard leaves the definition of users to the
implementation.