Comparing Users

dlgrossdlgross Posts: 17
edited January 12, 2005 12:58PM in SQL Compare Previous Versions
Where can I find more information about what is happening when Users are compared?

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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?
  • 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
  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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.
  • The SPMUser is a SQL Login
This discussion has been closed.