February 14, 2011 at 11:20 pm
Hi
what is relation between sysusers and syslogins?
how they are connected to eachother.
February 15, 2011 at 6:43 am
You may find this article useful.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
April 14, 2011 at 3:01 pm
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
April 14, 2011 at 3:12 pm
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.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply