Post reply

ALTER stored procedures Explicit Permission

  • September 7, 2010 at 4:34 am

    #225697

    Hi,

    We have a bunch of users that are assigned to a database role.

    I need to allow them to alter stored procedures, but I can't find the explicit permission to do this. They can currently CREATE and EXEC procedures, but I can't work out which permission would allow them to alter (I have assigned them the 'Alter' & 'Alter Schema' permissions, but these haven't worked).

    Thanks

  • September 7, 2010 at 5:28 am

    #1217252

    1) create a group and assign all the suers in that group.(It will be easy for your to manage)

    2) go to that perticular SP, right click and select properties. Go in permission tab.

    3) select the group which you created and allow alter permission as well.

    ----------
    Ashish

  • September 10, 2010 at 4:27 am

    #1219061

    Hi,

    The users are already set-up to inherit the roles from the database role as I stated in the original post.

    I do not want to set permissions on a stored procedure level (there are > 250 and are growing), but instead all procedures on the particular database.

    I need to be able to allow them to alter all stored procedures.

  • September 10, 2010 at 4:40 am

    #1219068

    then you can give reader and writer permission to related login/s for that specific database

    ----------
    Ashish

Viewing 4 posts - 1 through 3 (of 3 total)

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