I need to extract data from multiple database.
right now below is the step
1)Set up remote login with ID remote_profile
2)create proxy table with <SERVERNAME>.<database>.dbo.table1 with ID func_id
3)when I login by func_id I can extract the data from remote servers.
above works fine when login by func_id is used to get the data , How I can make it available for all the ids which has login?

Seems the proxy table created is tied with the ID that was used to create it and others cant use it?