Map Remote Logins to Particular Local Names

You can map remote logins to specific local names.

This example maps the login “pogo” from a remote system to the local login “bob”.

The user logs in to the remote system as “pogo”. When “pogo” executes remote procedure calls from GATEWAY, the local system maps the remote login name to “bob”.
create logn bob with password itsA8secret
sp_addremotelogin GATEWAY, bob, pogo