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.

About this task

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 create the user mappings for an Oracle data source, use :
Method Description
Issue the CREATE USER MAPPING statement to map the local user ID to the Db2 server user ID and password.
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.