Rechercher une page de manuel
alter_user
Langue: en
Version: 2008-01-03 (CentOS - 06/07/09)
Section: 7 (Divers)
NAME
ALTER USER - change a database roleSYNOPSIS
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)]Contenus ©2006-2024 Benjamin Poulain
Design ©2006-2024 Maxime Vantorre