alter_user

Langue: en

Autres versions - même langue

Version: 2007-04-20 (openSuse - 09/10/07)

Section: 7 (Divers)

Sommaire

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(7)], 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(7)]