I might be misreading your requirement, but what i guess that was what i was trying to say....

you have access to the remote server, right?

if you do, then you can create a role that has access to the specific database and tables your user needs. then create a logon and user that has that role.

then you can map your domain user on your regular server to use sql credentials via the linked server;

sample code, if you didn't use the GUI to do it on the remote server:

create database Whatever

GO

USE Whatever

--create the Role for my Dev guy

CREATE ROLE [WhateverDEVAdmins]

ALTER AUTHORIZATION ON SCHEMA::[db_ddladmin] TO [WhateverDEVAdmins]

ALTER AUTHORIZATION ON SCHEMA::[db_datareader] TO [WhateverDEVAdmins]

ALTER AUTHORIZATION ON SCHEMA::[db_datawriter] TO [WhateverDEVAdmins]

GRANT EXECUTE,ALTER TO [WhateverDEVAdmins]

--create role for my normal users

--now add specific users to nearly-Admins

IF NOT EXISTS (SELECT * FROM MASTER.dbo.syslogins WHERE name = N'myLinkedServerUser')

BEGIN

EXEC MASTER.dbo.sp_addlogin @loginame = N'myLinkedServerUser', @passwd = 'NotARealPassword', @defdb = N'WHATEVER', @deflanguage = N'us_english'

--add this user to permit read and write

END

USE [WHATEVER]

--make a user in the db for the matching login

CREATE USER [myLinkedServerUser] FOR LOGIN [myLinkedServerUser]

--add these logs to the role

EXEC sp_addrolemember N'WhateverDEVAdmins', N'myLinkedServerUser'