Multiple choice technology databases

Which table has all the users of a server?

  1. sysusers

  2. syslogins

  3. sysserverusers

  4. None of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The syslogins system table in the master database stores all SQL Server login accounts, which represent server-level authentication. sysusers is a database-level table containing database users and roles, not server logins. There is no system table called sysserverusers in SQL Server.

Keep practicing — related questions