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 |
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
 Posted - 2009-11-03 : 07:34:02
|
| I have set up a linked server and can query it OK, This may be a stupid question but how do I set up some of my users to access and query the server? |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-11-03 : 07:36:58
|
I would say: the same way you set up some of your users to query each other table?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
Posted - 2009-11-03 : 07:46:49
|
| Doh!Didn't realise I just give em permissions on the views set up.Cheers |
|
|
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
Posted - 2009-11-03 : 07:55:20
|
| Another questionDo I have to create views on all the tables in a linked server for them to access or can I set them up access any other way?That is apart from putting them in one of the server roles? |
|
|
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
Posted - 2009-11-03 : 08:10:48
|
| I don't want to put them into the setupadmin role if I can help it as i only want them to be able to acceee one of the linked servers, what's the best way forward on this? |
|
|
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
Posted - 2009-11-03 : 10:09:57
|
| OK, answer found, granted execute to the user on system stored procedure that controls access to linked servers. |
|
|
|
|
|
|
Linked server question?