Post reply

linked server creted permission to a user

  • February 5, 2014 at 3:41 am

    #282009

    I want to assign such rights to a remote user so he can create a new linked server and can change only those linked servers that are created by him. How can I accomplish this? I have read about granting these permissions

  • February 5, 2014 at 6:11 am

    #1686168

    i don't believe the permissions are that granular, so I don't believe you can do what you are asking.

    AFAIK, there is no owner for a linked server either.

    it's very rare that linked servers need to be added, updated or dropped, what situation are you in that you need to allow an individual to do this?

    if you REALLY need this functionality,can you make, say, a certificate signed stored proc that creates linked servers for that person, and grant EXECUTE on that proc to the user instead?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply