2

Hi,

I was wondering if someone knows a way round this. I have a database which needs to be accessed by a Windows Group with read only access. Some individuals in this group need write access.

I have added the group and then the individual logins and setup the permissions accordingly but the Windows Group seems to take precedence over the individual logins.

Does anyone know how to get around this?

Thanks

Andy

Improve this question

1 Answer 1

Reset to default
0

Permissions are cumulative, with the exception that DENY rights will overwrite GRANTs.

If you grant select to the group and deny update to the group, then grant update to the login they will not be able to update.

Make sure that you haven't denied any rights to the group or to public.

Improve this answer
2
  • Thank you I removed the deny from the specific columns and this is now working.
    – CodeFirstAndy
    Jan 21, 2010 at 10:50
  • No problem, glad it was that easy.
    – mrdenny
    Jan 23, 2010 at 6:43

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .