none
Execute permission denied for stored procedure

    Question

  • Hi,

    I have Admin database which has a stored procedure. This stored procedure retrieves the data from different reporting databases based on the connection provided. For granting the execute rigths to SP, I have created the Login at SQL server level and mapped the Admin database to it.
    When I execute the stored procedure using Windows Application, it works for one of the reporting database whereas it gives execute permission denied error for other reporting database.

    Can you please suggest how to handle this?

    Thanks in Advance
    Thursday, May 06, 2010 8:51 AM

Answers

All replies