Custom server permissions?

barrygilbertusa_no_spam_at_yahoo.com
Date: 11/24/04 

Date: 24 Nov 2004 09:21:48 -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

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: Awe diddums, fearless leader has gone into hiding.
    ... GRANT OF LICENSE. ... > non-exclusive rights: ... > ten copies of the SOFTWARE PRODUCT on computers, ... But from the 98DDK license itself, ...
    (alt.lang.asm)