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-SQLTo view the Windows groups that have access to the current database