alter_user

Langue: en

Version: 2008-01-03 (CentOS - 06/07/09)

Section: 7 (Divers)

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