question

Adrian avatar image
Adrian asked

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

sql-server-2005administrationpermissions
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
Steve Jones - Editor avatar image
Steve Jones - Editor answered

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?

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

alen teplitsky avatar image
alen teplitsky answered

can the user access the data that the SP touches?

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.