ALTER USER

ALTER USER

7

SQL - Language Statements

ALTER USER

change a database role

ALTER USER

role\_specification

\[ WITH \]

option

\[ \... \]

where

option

can be:

SUPERUSER \| NOSUPERUSER \| CREATEDB \| NOCREATEDB \| CREATEROLE \|
NOCREATEROLE \| INHERIT \| NOINHERIT \| LOGIN \| NOLOGIN \| REPLICATION
\| NOREPLICATION \| BYPASSRLS \| NOBYPASSRLS \| CONNECTION LIMIT

connlimit

\| \[ ENCRYPTED \] PASSWORD \'

password

\' \| PASSWORD NULL \| VALID UNTIL \'

timestamp

\' ALTER USER

name

RENAME TO

new\_name

ALTER USER {

role\_specification

\| ALL } \[ IN DATABASE

database\_name

\] SET

configuration\_parameter

{ TO \| = } {

value

\| DEFAULT } ALTER USER {

role\_specification

\| ALL } \[ IN DATABASE

database\_name

\] SET

configuration\_parameter

FROM CURRENT ALTER USER {

role\_specification

\| ALL } \[ IN DATABASE

database\_name

\] RESET

configuration\_parameter

ALTER USER {

role\_specification

\| ALL } \[ IN DATABASE

database\_name

\] RESET ALL

where

role\_specification

can be:

role\_name

\| CURRENT\_ROLE \| CURRENT\_USER \| SESSION\_USER

Description
===========

`ALTER USER` is now an alias for [`ALTER ROLE`](#sql-alterrole).

Compatibility
=============

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

See Also
========
