alter_user(5)

ALTER USER()              SQL Commands               ALTER USER()

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)].

COMPATIBILITY

     The ALTER USER statement is a PostgreSQL extension. The  SQL
     standard  leaves  the definition of users to the implementa-
     tion.

SEE ALSO

     ALTER ROLE [alter_role(5)]

SQL - Language StatementLast change: 2008-01-03 1