Creating the user mappings for an Oracle data source

To access an Oracle server, the federated server establishes a connection to the Oracle server by using a user ID and password that are valid for that data source.

About this task

Restrictions

The user ID at the Oracle data source must be created by using the Oracle create user command with the identified by clause, instead of the identified externally clause.

Procedure

Use one of the following methods to create the user mappings for an Oracle data source:

Method	Description
Use the Administration Explorer in Data Studio.	In the Federated Database Objects folder, right-click the User Mappings folder, and select Create User Mapping.
Issue the 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') ;`

What to do next

After you complete this task, test the connection to the Oracle server.