ALTER USER
Name
ALTER USER -- change a database role
Synopsis
ALTER USERname [ [ WITH ]option [ ... ] ]whereoption can be: SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE | NOCREATEROLE | CREATEUSER | NOCREATEUSER | INHERIT | NOINHERIT | LOGIN | NOLOGIN | REPLICATION | NOREPLICATION | CONNECTION LIMITconnlimit | [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password' | VALID UNTIL 'timestamp'ALTER USERname RENAME TOnew_nameALTER USERname SETconfiguration_parameter { TO | = } {value | DEFAULT }ALTER USERname SETconfiguration_parameter FROM CURRENTALTER USERname RESETconfiguration_parameterALTER USERname RESET ALLDescription
ALTER USER is now an alias forALTER ROLE.
Compatibility
TheALTER USER statement is aPostgreSQL extension. The SQL standard leaves the definition of users to the implementation.
