February 13, 2012 at 12:08 pm
I have a linked server that was set up to access only 4 specific tables on the server being linked. I have looked through BOL and this site for information on how to even create this kind of link. Everything I have read only describes how to create the database link but not down to the table level. Is there a stored proc that allows the addition of tables within the linked server configuration?
Thanks in advance!
kdsturg
February 13, 2012 at 2:21 pm
To the best of my knowledge there is no way to "add" tables/objects to the linked server scripts as this is all controlled by access level under the security tab. I am pretty certain of this...
The only thing I can think of is to create a user on the source server that only has access to those 4 tables, then when creating the linked server itself, use that user for the credentials.
I would reccomend researching the "Be made using the login's current security context" and "Be made using this security context" to see which one suits your needs best.
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply