Post reply

Grant execute to "user"

  • February 2, 2010 at 8:57 am

    #216070

    I'm needing to give execute permission to all the stored procedures in a db. I have found some elaborate procedures to do this, but found one post that suggest something quite simple:

    grant execute to "user"

    Has anyone used this before? Will this give too much permission...besides exe on SP's?

  • February 2, 2010 at 10:51 am

    #1112424

    I've used it and it does just what you've described - allows the user to execute user stored procedures and functions in the database. The drawback is you can't see the objects that the user has permission to execute in SSMS.

    Greg

  • February 2, 2010 at 10:57 am

    #1112430

    That's what I see as the drawback as well, when you look at the permissions to the stored procedure you don't see the user listed. Guess I'll just have to remember!

    Thanks for your answer.

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

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