Creating user mappings for JDBC data sources

You must define an association (a user mapping) between each federated server user ID and the corresponding data source user ID.

About this task

When you attempt to access a JDBC server, the federated server establishes a connection to the JDBC server by using a user ID and password for that data source.

Create a user mapping for each user ID that accesses the federated system to send distributed requests to the JDBC data source.

Procedure

Run the CREATE USER MAPPING statement to map a local user ID to the JDBC data source user ID and password:

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

The REMOTE_AUTHID and REMOTE_PASSWORD user mapping parameters are required.

What to do next

After you complete this task, you can test the connection to the JDBC data source.