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