If those are the only roles, the only groups and the only
permissions set for any users, groups or roles then yes.
Otherwise, it depends on other permissions granted/denied to
UserB and any roles or Windows groups that UserB is a member
of.
Permissions are cumulative based on the user and the roles
that the user is a member of. This would include Windows
groups as well and permissions granted to Windows groups
that a user is a member of. Deny will take precedence so if
the user is denied permissions directly or through another
group or role, the deny will take precedence.
-Sue
On Mon, 31 Jan 2005 17:48:36 GMT, "Do Park via
[quoted text, click to view] SQLMonster.com" <forum@SQLMonster.com> wrote:
>Hello all,
>
>There is a group GROUPA1 that contains another group GROUPB1. The
>GROUPA1 is a db_owner of DB1 database. UserB user belongs to GROUPB1.
>GROUPA1 and GROUPB1 use window authentication.
>
>Can UserB access the DB1 database?
>Can UseB have a db_owner?
>
>Thanks in advance,
>Do.