Re: Granting GRANT permissions

From: Kalen Delaney (replies_at_public_newsgroups.com)
Date: 09/09/05

  • Next message: Dan Guzman: "Re: Permissions!" 
    Date: Fri, 9 Sep 2005 14:09:20 -0700

     
    The owner of a stored procedure automatically has the ability to grant
    others the right to execute it. They do not need to be in any special role.

    HTH
    Kalen Delaney
    www.solidqualitylearning.com

    "Josh N." <Josh N.@discussions.microsoft.com> wrote in message
    news:6BA4EBA0-9BC5-4A84-BBA8-A18502BFB93E@microsoft.com...
    >I have the need to allow users GRANT permissions for their created stored
    > procedures. However I do not wish to give these users db_securityadmin
    > rights
    > in the database they will be creating said stored procedures in.
    >
    > Is there a way to only give them GRANT EXEC rights and nothing else? I
    > really don't like they idea they can modify groups and the users in those
    > groups with db_securityadmin rights as well as modify access rights to
    > tables.
    >
    > Thanks
    > Josh
    >
    >

  • Next message: Dan Guzman: "Re: Permissions!"

    Relevant Pages

    • 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: I still dont get it.
      ... > You can create a stored procedure to call xp_cmdshell to run a command. ... > though the originator has no such rights. ... > Russell Fields ... >> A has rights to sysadmin sproc, if I pass in the table to be created as ...
      (microsoft.public.sqlserver.security)
    • Re: Granting EXEC for read only SPs
      ... clearly understanding which stored procedures the user should have rights to ... problem is that the stored procedure is running under its own rights ... I created database role 'X' and granted EXEC permission for all SPs. ... the ones that modify data. ...
      (microsoft.public.sqlserver.security)
    • 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)