ALTER USER
change a database role
Synopsis
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.
Compatibility
The ALTER USER statement is a PostgreSQL extension. The SQL standard leaves the definition of users to the implementation.