Post reply

issues with Grant Execute

  • July 10, 2008 at 2:24 pm

    #188062

    I granted a user with execute right to a stored procedure which would delete data from a table. Somehow, the user still can't execute the sp unless Delete permission on the underlying table is granted as well. This really defeats the purpose of using a sp.

    The sp does not include any dynamic SQL script.

    Anybody know what the problem might be?

  • July 10, 2008 at 3:09 pm

    #841130

    I just tested and found out the login actually would work on SQL server even if I removed the delete permission to the underlying table. So most likely it's an application issue.

  • July 10, 2008 at 3:20 pm

    #841136

    Thanks for the update.

    Manu

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

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