Federation: Creating user mappings for DB2 data sources

A user mapping defines an association between a user ID and password at the federated server and the corresponding user ID and password at the data source server.

Whether or not user mappings are required for DB2 data sources depends on the configuration of the federated environment. If the environment uses federated trusted contexts and proxy authentication, none or only a few user mappings may be required. For best results, plan and set up federated trusted contexts before you create user mappings.

Procedure

To map the local user ID to the DB2® server user ID and password:

Issue a CREATE USER MAPPING statement.

For example:

CREATE USER MAPPING FOR local_userID SERVER server_definition_name
       OPTIONS (REMOTE_AUTHID 'remote_userID', REMOTE_PASSWORD 'remote_password')

The REMOTE_AUTHID is the connect authorization ID, not the bind authorization ID.