Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
lucsky8
Posting Yak Master
105 Posts |
Posted - 2013-03-14 : 09:33:35
|
Hi,If we have synonyms and i create a stored procedure.Do we need give read permission for the synonyms or just to SP?TksLuc |
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2013-03-14 : 14:21:59
|
if the synonym, underlying table, and stored procedure are all in the same database then all you need is EXEC on the SP (assuming you are not using dynamic sql).However if they are all not in the same database then the user needs explicit permissions to all the referenced remote objects whether that is a direct referernce (table reference) or indirect reference (table reference via synonym).Be One with the OptimizerTG |
|
|
lucsky8
Posting Yak Master
105 Posts |
Posted - 2013-03-14 : 14:30:47
|
Tks for the fast response!quote: Originally posted by TG if the synonym, underlying table, and stored procedure are all in the same database then all you need is EXEC on the SP (assuming you are not using dynamic sql).However if they are all not in the same database then the user needs explicit permissions to all the referenced remote objects whether that is a direct referernce (table reference) or indirect reference (table reference via synonym).Be One with the OptimizerTG
|
|
|
|
|
|