Merits of Database Logins being different from Server Logins

• okhere

  SSC-Addicted

  Points: 443

  More actions

  January 10, 2012 at 12:27 pm

  #253136

  Hi DBAs,

  Just wondering if there are merits to Database Logins being different from Server Logins. For example, you login to the server, read your email and access your drives using your Login Id, but when you access the SQL Database, you always connect to it using a different Login, also your own. This means you have dual identities in Active Directory.

  Should we have it like that? or use just one Active Directory Login?

  Thanks,

  Osama

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  January 11, 2012 at 8:28 am

  #1431838

  There are some people who believe for security purposes that DBA's should have a separate AD account for sa access while your standard AD account only has minimal rights.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question