Hi, not trying to hijack this post, but I have a question I cannot seem to find the answer to.

When a user is a member of multiple AD groups, that have corresponding logins all on the same instance, with different default databases, which 'group' rules?

for example.

ADGroup1, read access to DB1, defaultDB =DB1,

ADGroup2, dbo access to DB2, defaultDB DB2,

ADGroup3, read access to DB3, defaultDB = DB3.

upon connecting, what will be the default db?

thanks for any input...