Custom server permissions?

barrygilbertusa_no_spam_at_yahoo.com
Date: 11/24/04

  • Next message: barrygilbertusa_no_spam_at_yahoo.com: "Custom server permissions?" 
    Date: 24 Nov 2004 09:18:53 -0800

    Hi,

    I need to grant a user access to one or two specific system stored
    procs without giving permission to everything else in the fixed server
    role that allows them. Specifically, they need rights to
    sp_addlinkedserver and sp_addlinkedsrvlogin, but they shouldn't have
    all the rights associated with securityadmin. Is there a way to grant
    specific rights to just these?

    TIA,
    Barry

  • Next message: barrygilbertusa_no_spam_at_yahoo.com: "Custom server permissions?"

    Relevant Pages

    • Custom server permissions?
      ... I need to grant a user access to one or two specific system stored ... procs without giving permission to everything else in the fixed server ... all the rights associated with securityadmin. ...
      (microsoft.public.sqlserver.security)
    • Re: OT: WTF is a "Super Delegate"
      ... Rights are completely different than entitlements, privileges, etc. ... no person or governing body can ... insist that the word "grant" be used your BS is ripped apart. ... Rights," as Wyoming was the first government in the world ...
      (comp.sys.mac.advocacy)
    • Re: access to other mailboxes
      ... Sorry - I didn't realize how vague that sounded - go to the permissions tab ... of the recipient and grant the user Admin rights to the mailbox. ...
      (microsoft.public.exchange.admin)
    • Re: OT: WTF is a "Super Delegate"
      ... Constitution or if the rights were granted in some other way ... ... Steve, seriously, do you not see the flaw in that? ... Tim notes he does not know if any states use the word "grant" in their ...
      (comp.sys.mac.advocacy)
    • Re: Facts that piss off trolls
      ... Snit wrote: ... The Constitution doesn't "grant" any rights. ...
      (comp.sys.mac.advocacy)