Home Forums SQL Server 2005 Administering granting execute permissions to ALL stored procedure RE: granting execute permissions to ALL stored procedure

  • January 11, 2011 at 2:43 pm

    #1272104

    david.alcock (1/11/2011)

    But you could place certain procs, not all, into a schema and assign the permissions to a role at schema level cant you?

    Yes it may be painful to put all the objects in the necessary container to begin with but after then, new users the process is quite simple.

    I'm playing with your idea now; can you post an example of how you do it, david?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!