sql 2k5 effective permissions list not containing the explicit permissions

Hi,

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

asked Oct 16 '09 at 11:16 PM in Default

Adrian
31 ● 1 ● 1 ● 1

(comments are locked)

2 answers:

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 '09 at 12:40 PM

Steve Jones - Editor ♦♦
5.1k ● 74 ● 78 ● 82

Hi,

thank you for getting back to me. it is a new user and a new role and they do not have any deny.

Thank you, Adrian

Oct 17 '09 at 02:11 PM Adrian

Are there any DENY's on public/guest?

Oct 18 '09 at 04:18 PM RBarryYoung

Also, check the explicit permissions for the user to see if your GRANT shows up there.

Oct 18 '09 at 04:19 PM RBarryYoung

Yes, the Grant does show up, that is why I am puzzled, there is an execute granted in explicit which is not refleted in the effective ... it seems as serious bug to me. Thank you

Oct 18 '09 at 11:15 PM Adrian

(comments are locked)