July 17, 2012 at 12:42 pm
Is it possible to restrict access to some but not all Linked Servers?
I want Developers to be able to have access to all but one Linked Server.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 18, 2012 at 8:15 am
I don't know of a way to keep anyone from being able to see that the linked server exists but you can use the local login to remote login mappings to keep users from using linked servers. See this BOL Topic.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 18, 2012 at 9:21 am
Configure the linked server to use caller's own credentials. Then they will only be able to use the linked servers for which they have permission on the remote server.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply