ALTER USER <refpurpose>change a database role</refpurpose> — データベースロールを変更する
ALTER USERrole_specification
[ WITH ]option
[ ... ] <phrase>where <replaceable class="parameter">option</replaceable> can be:</phrase>option
は次の通りです。 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_name
ALTER USER {role_specification
| ALL } [ IN DATABASEdatabase_name
] SETconfiguration_parameter
{ TO | = } {value
| DEFAULT } ALTER USER {role_specification
| ALL } [ IN DATABASEdatabase_name
] SETconfiguration_parameter
FROM CURRENT ALTER USER {role_specification
| ALL } [ IN DATABASEdatabase_name
] RESETconfiguration_parameter
ALTER USER {role_specification
| ALL } [ IN DATABASEdatabase_name
] RESET ALL <phrase>where <replaceable class="parameter">role_specification</replaceable> can be:</phrase> ここでrole_specification
は以下の通りです。role_name
| CURRENT_ROLE | CURRENT_USER | SESSION_USER
<command>ALTER USER</command> is now an alias for
<link linkend="sql-alterrole"><command>ALTER ROLE</command></link>.
ALTER USER
はALTER ROLE
の別名になりました。
The <command>ALTER USER</command> statement is a
<productname>PostgreSQL</productname> extension. The SQL standard
leaves the definition of users to the implementation.
ALTER USER
文は、PostgreSQLの拡張です。
標準SQLでは、ユーザの定義は実装に任されています。