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'    | PROFILEprofile_name    | ACCOUNT UNLOCK | ACCOUNT LOCKALTER 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 aPostgres Pro extension. The SQL standard leaves the definition of users to the implementation.

See Also