Viewing Database Users

Viewing a Microsoft® SQL Server™ user account in a database shows:

• The roles of which the user is a member.
  
  
• The SQL Server login associated with the user.
  
  
• The default database.

Use this information to understand how the user fits into the security system of the database.

To view a database user

Transact-SQL