Index for Section USER

Alphabetical listing for A

Bottom of page

ALTER
NAME
  ALTER USER - change a database role

SYNOPSIS
  ALTER USER name [ [ WITH ] option [ ... ] ]

  where option can be:

	SUPERUSER | NOSUPERUSER
      | CREATEDB | NOCREATEDB
      | CREATEROLE | NOCREATEROLE
      | CREATEUSER | NOCREATEUSER
      | INHERIT | NOINHERIT
      | LOGIN | NOLOGIN
      | CONNECTION LIMIT connlimit
      | [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password'
      | VALID UNTIL 'timestamp'

  ALTER USER name RENAME TO newname

  ALTER USER name SET configuration_parameter { TO | = } { value | DEFAULT }
  ALTER USER name RESET configuration_parameter

DESCRIPTION
  ALTER USER is now an alias for ALTER ROLE [alter_role(5)], which see for
  more information.

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

SEE ALSO
  ALTER ROLE [alter_role(5)]

Index for Section USER

Alphabetical listing for A

Top of page