I have two database servers ( server 1 and 2).
Server 1 is a test server and server 2 is a development server.
User has access to server 2.
I want to give a user (working on server 2) select rights on a few tables on server 1 trough queries, views etc.
What do I have to do to arange this? And how about security?