Post reply

Automatically Grant Execute to SP

  • March 19, 2013 at 8:43 am

    #394421

    Hi,

    is there a way to set "Grant Execute to [domain \ Active Directory Group] automatically without explicit Grant Execute to ....

    Once a new SP is added, is automatic. Grant to be set.

    Thank you

    Regards

    Nicole 😉

  • March 19, 2013 at 9:03 am

    #1598482

    Since SQL2005 there is a much better way to do so:

    CREATE ROLE db_executor

    GRANT EXECUTE TO db_executor

    The above will create database role which will have rights to execute all procs and functions in the database. So, as soon as you assign your user to this role, these rights will be granted to him.

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

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

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