Feedback
latest
CREATE USER MAPPING
¶
Create a user mapping for a foreign server.
Table of contents
Synopsis¶
CREATE USER MAPPING [ IF NOT EXISTS ] FOR { user_name | USER | CURRENT_ROLE | CURRENT_USER }
SERVER server_name
[ OPTIONS ( option value [ , ... ] ) ]
Description¶
CREATE USER MAPPING
is a DDL statement that maps a CrateDB user to another
user on a foreign server.
To create a user mapping you must first create a foreign server using CREATE SERVER.
The created user mappings will be used whenever a foreign table is queried. If no user mapping exists, foreign data wrappers usually attempt to connect with the username of the current CrateDB user. How exactly is specific to the concrete foreign data wrapper implementation. See Foreign Data Wrappers for more details.
Creating a user mapping requires AL
permission on cluster level.
User mappings are visible in the user_mappings table and the options in user_mapping_options.
Parameters¶
- user_name
The name of the CrateDB user.
- server_name
Name of the server for which to create the user mapping. See CREATE SERVER.