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 |
|
ostinoh
Yak Posting Veteran
66 Posts |
 Posted - 2012-01-09 : 12:59:32
|
| Hello – I’m on a project where I created two Synonyms I called TimeDataFetchCurrent and the other TimeDataFetchOld.(Synonym) TimeDataFetchCurrent is referencing my table TimeDataFresh and (Synonym) TimeDataFetchOld is referencing table TDFBUsers are connecting within Excel to the database server and want them to only use TimeDataFetchCurrent . This way they can pull in the data and report off of it.My question is there a way to lock down the tables and only have people see and choose the TimeDataFetchCurrent Synonym when setting this up? Didn’t know if I set the permissions Synonoym if they would carry over and give the table permission as well.Thoughts??Regards,D |
|
|
Sachin.Nand
2937 Posts |
Posted - 2012-01-09 : 13:42:45
|
| No it wont.The underlying table wont have direct access.After Monday and Tuesday even the calendar says W T F .... |
 |
|
|
|
|
|
Synonyms Permissions?