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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy