Re: Granting GRANT permissions

From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 09/09/05

  • Next message: Kalen Delaney: "Re: Granting GRANT permissions" 
    Date: Fri, 9 Sep 2005 22:18:20 +0100

    Creators of stored procedures (standard users with CREATE PROCEDURE rights)
    can grant permissions on their own procedures to other users. Is this what
    you mean? i.e. if user A has CREATE PROCEDURE rights they can create a
    procedure (A.P1) and then grant permissions on it to another user B (grant
    exec on A.P1 to B). This is without them being in any other role than public
    in the database. 

    -- 
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"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: Kalen Delaney: "Re: Granting GRANT permissions"

    Relevant Pages

    • Re: Granting GRANT permissions
      ... How do I allow a user to create a stored procedure for 'dbo' without giving ... that errors out saying you can't use AS when granting those rights. ... > can grant permissions on their own procedures to other users. ...
      (microsoft.public.sqlserver.security)
    • Re: mask one users permission level to another
      ... Alternatively if you are using NT Authentication you can ... and grant permissions to a NT User group; you would then only need to add ... the users to that NT User group. ... > If there is a user A that has been granted certain rights on certain ...
      (microsoft.public.sqlserver.security)
    • Re: Granting GRANT permissions
      ... not DBO, but you can act as the owner of the object. ... > that errors out saying you can't use AS when granting those rights. ... >> Creators of stored procedures (standard users with CREATE PROCEDURE ... >> procedure and then grant permissions on it to another user B ...
      (microsoft.public.sqlserver.security)
    • Re: Set identity_insert
      ... You don't grant permissions to the SET IDENTITY_INSERT statement. ... Most good judgment comes from experience. ... i have a login with role who have rights ... Grant Select, update, insert, delete, view definition to onLine --online ...
      (microsoft.public.sqlserver.security)
    • Re: Writing updates from a wide DataTable
      ... restrict IO rights to specific columns or trip over a column that can't be ... Creating your own UPDATE statement on the fly is what ADO classic did--based ... This posting is provided "AS IS" with no warranties, and confers no rights. ... >following the recommendations to use stored procedures to apply updates to ...
      (microsoft.public.dotnet.framework.adonet)