Groups | Blog | Home
all groups > sql server connect > january 2005 >

sql server connect : User access to database?


Sue Hoegemeier
1/31/2005 5:33:20 PM
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]
Do Park via SQLMonster.com
1/31/2005 5:48:36 PM
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.

--
AddThis Social Bookmark Button