April 5, 2012 at 12:15 pm
We have a linked server that is set up between 2 production servers and I'm wondering what permissions are used.
The same LS is used for all connections between these 2 servers. There are many different combinations that could exist. For example:
Server1.DB1 could have permission to use Server2.DB2 using linked server LS1
Server1.DB3 could have permission to use Server2.DB4 using linked server LS1
Can a user that has permissions in Server1.DB1 access Server2.DB4 using LS1?
Does any user that has read permissions in Server1.DB1 have read permissions in Server2.DB2 or do they need to use LS1 to access Server2.DB2?
Thanks,
James
April 5, 2012 at 12:28 pm
A linked server functions as the login that is used to establish the linked server. That means that it has whatever permissions are granted to the user or role that is defined in the linked server. Does that help answer your question?
This article will probably explain this far better than I can. http://msdn.microsoft.com/en-us/library/ms175537%28v=sql.105%29.aspx
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply