ALTER USER — change a database role
ALTER USERname
[ [ WITH ]option
[ ... ] ] whereoption
can be: SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE | NOCREATEROLE | CREATEUSER | NOCREATEUSER | INHERIT | NOINHERIT | LOGIN | NOLOGIN | CONNECTION LIMITconnlimit
| [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password
' | VALID UNTIL 'timestamp
' ALTER USERname
RENAME TOnewname
ALTER USERname
SETconfiguration_parameter
{ TO | = } {value
| DEFAULT } ALTER USERname
RESETconfiguration_parameter