August 9, 2013 at 12:20 pm
I have a user who has DB_Owner permission on a particular database.
Now, that user needs to create a linked server for himself.
what level of permission do I need to grant to that user at the server level for him to create Linked Server?
August 9, 2013 at 1:02 pm
Can I get some help please
August 9, 2013 at 1:12 pm
Did you try google?
"SQL permission to create linked server" search returned this link first:
August 9, 2013 at 1:19 pm
I dont need to know the procedure to create Linked Server. However, I know it.
I would want to let a user create linked server on his own. Does he need sysadmin permission to create it was my question
August 9, 2013 at 1:39 pm
Benki Chendu (8/9/2013)
I dont need to know the procedure to create Linked Server. However, I know it.I would want to let a user create linked server on his own. Does he need sysadmin permission to create it was my question
That article does address your question. See the section titled (and hyperlinked) named SECURITY under "Before you Begin".
August 9, 2013 at 3:27 pm
The user needs the permission ALTER ANY LINKED SERVER.
I strongly recommend that you don't give the user this permission, but that you create the server for him.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply