chrisph
Hall of Fame
Points: 3701
More actions
May 3, 2011 at 8:49 am
#250150
Hi all,
How do I grant a domain account user persmissions to be able to access/query a linked server? I want a DB developer to be able to access this linked server, but I have no idea what permissions are required.
Thanks
May 3, 2011 at 10:05 am
#1319200
Found the resolution to this.
- The user needs to have the public role in the master database, explicitly mapped.
- Run the following command: Grant Execute on sys.xp_prop_oledb_provider to [login];
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply