Default Database when user is in multiple NT Groups

• ellen feller

  SSC Enthusiast

  Points: 171

  More actions

  July 20, 2006 at 2:03 pm

  #61460

  We are using Windows NT Authentication.  Each developer is part of some domain group.  The appropriate domain groups are granted access to one or more databases with various roles and various default databases.

  Here's the issue...(the groups permissions are all 'system admin' and they all have 'dbo' database roles..this is a DEV server)

  'User A' belongs to a domain group (WindowsDomain\GroupA) and the default database for that group is 'Database A'

  'User A' also belongs to ANOTHER domain group (WindowsDomain\GroupB) and the default db for that group is 'Database B'.

  How can I know which database the user will default into?  Is the only way to force one or the other to make an individual login for the user?

  Any thoughts?  Thanks!

• Rudyx - the Doctor

  SSC-Forever

  Points: 43695

  More actions

  July 21, 2006 at 11:38 am

  #650813

  Please do not post the same topic multiple times ...

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=296039

  RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."