Post reply

Application Role and Stored Procedure

  • April 26, 2012 at 10:43 am

    #267982

    I have set a database into Application Role and within this database I have a Stored Procedure that I need to run several times during the application.

    However, the Stored Procedure only runs once and then on the second time of being called SQL Server says that I do not have Execute permission!

    Has anyone come across this before me?

  • April 26, 2012 at 12:59 pm

    #1480013

    What does the proc do? It, or something else in the stack, may be changing your security context using EXECUTE AS or sp_unsetapprole. Can you post the procedure code?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

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

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