Contents
ALTER USER MAPPING
An SQL command for modifying the mapping of a user to a foreign server
ALTER USER MAPPING is a DDL command for modifying the mapping of a PostgreSQL database user to a foreign server.
ALTER USER MAPPING was added in PostgreSQL 8.4.
Change history
- PostgreSQL 14
ALTER USER MAPPING ... OWNER TO CURRENT_ROLEsyntax added (commit 45b98057)
- PostgreSQL 8.4
- added (commit cae565e5)
Examples
Usage example for ALTER USER MAPPING:
postgres=# CREATE USER MAPPING FOR CURRENT_USER SERVER fdw_test OPTIONS (user 'foo', password 'bar'); CREATE USER MAPPING postgres=# ALTER USER MAPPING FOR postgres SERVER fdw_test OPTIONS (SET password 'baz'); ALTER USER MAPPING
Note that if an option is provided without specifying one of ADD, SET or DROP, ADD is assumed. This will result in an error if the option was previously set, e.g.:
postgres=# ALTER USER MAPPING FOR postgres SERVER fdw_test OPTIONS (password 'zoo); ERROR: option "password" provided more than once
In this case SET must be explicitly provided.
Conversely, if SET is provided for an option which was not previously added, an error will also occur:
postgres=# CREATE USER MAPPING FOR foo SERVER fbw_test options(username 'bar'); CREATE USER MAPPING postgres=# ALTER USER MAPPING FOR foo SERVER fdw_test OPTIONS (SET password 'baz'); ERROR: option "password" not found
References
- PostgreSQL documentation: ALTER USER MAPPING