Creating the user mappings for a Sybase data source
When you attempt to access a Sybase server, the federated server establishes a connection to the Sybase server by using a user ID and password that are valid for that data source. You must define an association (a user mapping) between each federated server user ID and password and the corresponding data source user ID and password.
About this task
Create a user mapping for each user ID that will access the federated system to send distributed requests to the Sybase data source.
Procedure
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');