Relation between sysusers and syslogins

• vamsi.341

  Right there with Babe

  Points: 763

  More actions

  February 14, 2011 at 11:20 pm

  #245477

  Hi

  what is relation between sysusers and syslogins?

  how they are connected to eachother.

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  February 15, 2011 at 6:43 am

  #1287018

  You may find this article useful.

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga

• Ysaias Portes-QUI Group

  SSCrazy

  Points: 2127

  More actions

  April 14, 2011 at 3:01 pm

  #1311872

  sysusers Contains one row for each Microsoft Windows user, Windows group, Microsoft SQL Server user, or SQL Server role in the database.

  http://msdn.microsoft.com/en-us/library/ms179871.aspx

  while syslogins contains the login account.

  Having a login does not mean you have access to a database or having a user does not mean that you can connect to SQL or have access to the database.

  A user must be linked to a login to complete the database access.

  QUIGROUP- Need a Certified experienced DBA for a project or troubleshooting? Need help with programming, database recovery, performance tuning, ETL, SSRS or developing new databases? Contact us.. 1-786-273-9809

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738277

  More actions

  April 14, 2011 at 3:12 pm

  #1311881

  These are old views, for compatibility purposes. Don't use them.

  sysusers has been superseded by sys.database_principals (http://msdn.microsoft.com/en-us/library/ms187328.aspx)

  syslogins has been superseded by sys.server_principals (http://msdn.microsoft.com/en-us/library/ms188786.aspx) and sys.sql_logins (http://msdn.microsoft.com/en-us/library/ms174355.aspx)

  Logins exist at a server instance level, users are in a database. They are mapped from a user to a login.