| PostgreSQL 8.2.6 Documentation | ||||
|---|---|---|---|---|
| Prev | Fast Backward | Fast Forward | Next | |
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
The ALTER USER statement is a PostgreSQL extension. The SQL standard leaves the definition of users to the implementation.