Test connections with NT User groups

27 Nov 2007 5:56 PM

SM

Hi

I've created multiple NT User groups with different SQL Server permissions,
each group contain some NT users.
I want to test if my permission policy is correct, is there a way to do this
without asking one people from each group to test ?

What happen if the same user exists in two NT User groups with different
permissions ?

Thank you

27 Nov 2007 6:07 PM

Ben Nevarez

The user will be granted the permissions granted to both groups. DENY
permissions take precence over GRANT permissions.

Hope this helps,

Ben Nevarez
Senior Database Administrator
AIG SunAmerica

Show quote

"SM" wrote:

> Hi
>
> I've created multiple NT User groups with different SQL Server permissions,
> each group contain some NT users.
> I want to test if my permission policy is correct, is there a way to do this
> without asking one people from each group to test ?
>
> What happen if the same user exists in two NT User groups with different
> permissions ?
>
> Thank you
>
>
>

27 Nov 2007 7:51 PM

Ben Nevarez

You can impersonate another user to test his/her permissions by using
SETUSER.

Hope this helps,

Ben Nevarez
Senior Database Administrator
AIG SunAmerica

Show quote

"SM" wrote:

> Hi
>
> I've created multiple NT User groups with different SQL Server permissions,
> each group contain some NT users.
> I want to test if my permission policy is correct, is there a way to do this
> without asking one people from each group to test ?
>
> What happen if the same user exists in two NT User groups with different
> permissions ?
>
> Thank you
>
>
>