Comparing Users

• 
  Hello,
  
  Thanks for your post. The information about users comes from the syslogins system table. Is there a specific thing you want to know about the way that it compares them?

  Brian Donahue January 11, 2005 13:52

  - 0 +
• 
  Why is comparison showing the databases as different for the following user?
  1st database
  -- User
  if not exists (select * from master.dbo.syslogins where loginname = N'SpmUser')
  exec sp_addlogin N'SpmUser'
  GO
  sp_grantdbaccess N'SpmUser', N'SpmUser'
  GO
  2nd database
  -- User
  if not exists (select * from master.dbo.syslogins where loginname = N'SpmUser')
  exec sp_addlogin N'SpmUser'
  GO
  sp_grantdbaccess N'SpmUser'
  GO

  dlgross January 12, 2005 10:24

  - 0 +
• 
  Is SpmUser a Windows logon, or a SQL one? Unfortunately, SQL Compare differentiates Windows security users if they are from different machines. In other words, MACHINE1\ASPNET is not the same as MACHINE2\ASPNET.

  Brian Donahue January 12, 2005 10:35

  - 0 +
• 
  The SPMUser is a SQL Login

  dlgross January 12, 2005 12:58

  - 0 +

Add comment

Please sign in to leave a comment.