English

CREATE USER MAPPING

Defines a new mapping from users to external servers.

Synopsis

CREATE USER MAPPING FOR { username | USER | CURRENT_USER | PUBLIC }
    SERVER servername
    [ OPTIONS ( option 'value' [, ... ] ) ]

CREATE USER MAPPING Defines the user's mapping to an external server. You must be the owner of the server to define user mappings for it.

username

The name of the existing user mapped to the external server. CURRENT_USER and USER match the name of the current user. PUBLIC is used to match all current and future user names in the system.

servername

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

Options for new user mapping. These options usually define the actual username and password for the map. The option name must be unique. The option name and value are specific to the server-specific external data wrapper.

Create user maps between user bob and server foo:

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

CREATE USER MAPPING complies with ISO/IEC 9075-9 (SQL/MED).