sql permission - database level

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sg - 14 Jul 2008 15:04 GMT

Hello,

I'm reorganizing users in database db1. Just simple question, however it
always confuses me.
When I chose a few permission groups, would final effective rights be AND or
OR combination of those permission? In other word, would it be most and least
combination?
I hope I explained my question clearly,
Thanks a lot in advance,
Sg

Reply to this Message

Russell Fields - 14 Jul 2008 17:04 GMT

sg,

Rights OR together. But remember that DENY overrides GRANT, just in case
you run into a surprise.

RLF

> Hello,
>
[quoted text clipped - 8 lines]
> Thanks a lot in advance,
> Sg

Reply to this Message

sg - 14 Jul 2008 17:55 GMT

Hi Russell,

Thanks very much for your response. It's very clear answer and helpful

Sarah

> sg,
>
[quoted text clipped - 15 lines]
> > Thanks a lot in advance,
> > Sg

Reply to this Message