alter_user(7)

ALTER USER \nrole_specification\n [ WITH ] \noption\n [ ... ]
where \noption\n can be:
\n
      SUPERUSER | NOSUPERUSER
\n
    | CREATEDB | NOCREATEDB
\n
    | CREATEROLE | NOCREATEROLE
\n
    | INHERIT | NOINHERIT
\n
    | LOGIN | NOLOGIN
\n
    | REPLICATION | NOREPLICATION
\n
    | BYPASSRLS | NOBYPASSRLS
\n
    | CONNECTION LIMIT \nconnlimit\n
\n
    | [ ENCRYPTED ] PASSWORD '\npassword\n' | PASSWORD NULL
\n
    | VALID UNTIL '\ntimestamp\n'
ALTER USER \nname\n RENAME TO \nnew_name\n
ALTER USER { \nrole_specification\n | ALL } [ IN DATABASE \ndatabase_name\n ] SET \nconfiguration_parameter\n { TO | = } { \nvalue\n | DEFAULT }
ALTER USER { \nrole_specification\n | ALL } [ IN DATABASE \ndatabase_name\n ] SET \nconfiguration_parameter\n FROM CURRENT
ALTER USER { \nrole_specification\n | ALL } [ IN DATABASE \ndatabase_name\n ] RESET \nconfiguration_parameter\n
ALTER USER { \nrole_specification\n | ALL } [ IN DATABASE \ndatabase_name\n ] RESET ALL
where \nrole_specification\n can be:
\n
    \nrole_name\n
\n
  | CURRENT_ROLE
\n
  | CURRENT_USER
\n
  | SESSION_USER