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 - 2015-02-23 : 10:23:16
|
| Can anyone tell me what the grant permissions would be to give a user permissions to use a linked server and to see the catalog on it?Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-02-23 : 12:14:03
|
| I'm not sure that linked servers are sophisticated enough, but they can connect to the actual server behind the linked server to see the catalog.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
Posted - 2015-02-24 : 00:26:23
|
| OK, thanks, going to need a rethink on this one as the user needs to see the fields in the tables/views on the linked server and not just blindly select * from tablename. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-02-24 : 12:29:44
|
| They could query the INFORMATION_SCHEMA views through the linked server.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Grant permissions