Movatterモバイル変換

ALTER USER

ALTER USER — change a database role

Synopsis

ALTER USERrole_specification [ WITH ]option [ ... ]whereoption can be:      SUPERUSER | NOSUPERUSER    | CREATEDB | NOCREATEDB    | CREATEROLE | NOCREATEROLE    | INHERIT | NOINHERIT    | LOGIN | NOLOGIN    | REPLICATION | NOREPLICATION    | BYPASSRLS | NOBYPASSRLS    | CONNECTION LIMITconnlimit    | [ ENCRYPTED ] PASSWORD 'password' | PASSWORD NULL    | VALID UNTIL 'timestamp'ALTER USERname RENAME TOnew_nameALTER USER {role_specification | ALL } [ IN DATABASEdatabase_name ] SETconfiguration_parameter { TO | = } {value | DEFAULT }ALTER USER {role_specification | ALL } [ IN DATABASEdatabase_name ] SETconfiguration_parameter FROM CURRENTALTER USER {role_specification | ALL } [ IN DATABASEdatabase_name ] RESETconfiguration_parameterALTER USER {role_specification | ALL } [ IN DATABASEdatabase_name ] RESET ALLwhererole_specification can be:role_name  | CURRENT_ROLE  | CURRENT_USER  | SESSION_USER

Description

ALTER USER is now an alias forALTER ROLE.

Compatibility

TheALTER USER statement is aPostgreSQL extension. The SQL standard leaves the definition of users to the implementation.

See Also