create_user_mapping(7)

NAME#

CREATE_USER_MAPPING - define a new mapping of a user to a foreign server

SYNOPSIS#

CREATE USER MAPPING [ IF NOT EXISTS ] FOR { \nuser_name\n | USER | CURRENT_ROLE | CURRENT_USER | PUBLIC }
\n
    SERVER \nserver_name\n
\n
    [ OPTIONS ( \noption\n '\nvalue\n' [ , ... ] ) ]

DESCRIPTION#

CREATE USER MAPPING defines a mapping of a user to a foreign server. A user mapping typically encapsulates connection information that a foreign-data wrapper uses together with the information encapsulated by a foreign server to access an external data resource.

The owner of a foreign server can create user mappings for that server for any user. Also, a user can create a user mapping for their own user name if USAGE privilege on the server has been granted to the user.

PARAMETERS#

IF NOT EXISTS

user_name

server_name

OPTIONS ( option 'value' [, ... ] )

EXAMPLES#

Create a user mapping for user bob, server foo:

CREATE USER MAPPING FOR bob SERVER foo OPTIONS (user 'bob', password 'secret');

COMPATIBILITY#

CREATE USER MAPPING conforms to ISO/IEC 9075-9 (SQL/MED).

SEE ALSO#

ALTER USER MAPPING (ALTER_USER_MAPPING(7)), DROP USER MAPPING (DROP_USER_MAPPING(7)), CREATE FOREIGN DATA WRAPPER (CREATE_FOREIGN_DATA_WRAPPER(7)), CREATE SERVER (CREATE_SERVER(7))