I have this sql 2k5 db and noticed something weird: I have this new user A in the role_A and give the role_A excecute permission on the stored procedure SP, also gave user A execute permission in on the SP. Checked Effective permssions for user A on SP and there is no execute. I do not need to mention that user A cannot execute SP !! How can that be? What am I missing?
This is critical
Thank you in advance Adrian
Please show the code you used.
Have you checked for a DENY for the user or a role the user is in on that object?
answered Oct 17, 2009 at 12:40 PM
Steve Jones - Editor ♦♦
can the user access the data that the SP touches?
answered Oct 21, 2009 at 04:41 PM