Manual Reference Pages  - ALTER USER ()

NAME

ALTER USER - change a database role

CONTENTS

Synopsis

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 parameter { TO | = } { value | DEFAULT } ALTER USER name RESET 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)]


SQL - Language Statements ALTER USER () 2010-12-14
blog comments powered by Disqus