Mapping remote logins to particular local names

The following 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