Post reply

Sproc permissions

  • November 23, 2012 at 4:35 am

    #271144

    Need to grant DEV access to script out sprocs on LIVE. What permissions are needed.

  • November 23, 2012 at 4:42 am

    #1561825

    You can give them alter permissions and exec permissions as this will

    Allow them to develop the procedure and also they can unit test it.

  • November 23, 2012 at 4:49 am

    #1561826

    Will that not give them access to run and alter any sproc on LIVE. This is what I'm trying to avoid. I just want to grant them the option to script out the sproc. Does view definition allow this.

  • November 23, 2012 at 4:52 am

    #1561828

    emile.milne (11/23/2012)

    Does view definition allow this.

    The best way to find out is to try it. You'll probably learn something you didn't know along the way, as well.

    John

  • November 23, 2012 at 5:09 am

    #1561835

    View definition is all that is needed THANKS.

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

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