SQL ORACLE
One Orange Chip
Points: 27807
More actions
August 18, 2008 at 1:47 pm
#99220
A user would like to create a linked server from his own. I would like to grant him the minimum permission in doing so. What is the minimum permission I should grant him?
Any input will be greatly appreciated.
Jack Corbett
SSC Guru
Points: 184394
August 18, 2008 at 2:05 pm
#859661
Do you mean what permissions you should grant on his server or on the one he wants to connect to using a linked server?
In order to create a linked server according to BOL you need:
PermissionsRequires ALTER ANY LINKED SERVER permission.
Permissions
Requires ALTER ANY LINKED SERVER permission.
This would be for creating the linked server on his server.
On your server the account used to connect from his server needs access to your server and rights in a database just like any other user.
Jack CorbettConsultant - Straight Path SolutionsCheck out these links on how to get faster and more accurate answers:Forum Etiquette: How to post data/code on a forum to get the best help Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply