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
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.
Use one of the following methods to create the user mappings for an Oracle data source:
|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:
After you complete this task, test the connection to the Oracle server.