Post reply

Procedures with Execute as wont run unless DB_Owner

  • January 22, 2009 at 5:45 am

    #199093

    Howdy all,

    I have created some procedures with Execute as and if you are an Admin or DB_Owner they work fine.

    How can I have a non DB_Owner run them?

    I'm guessing I may need to create a new role, but I am not sure what permissions I would have to give them to allow this to happen.

    Any Ideas?

    Desperate Doug

  • June 12, 2009 at 11:49 am

    #1008832

    Hello

    Yes you can do this by creating a new role. I call the role sp_execute. You then add your role members (the users who will be able to execute the procedure) and then list your Securables (The stored procedures the users will be able to execute). Then for each stored procedure added you will need to grant the Execute permission.

    hope this helps!

  • June 12, 2009 at 2:44 pm

    #1008903

    Thanks for this

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

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