To view a database userViewing 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, and the default database. You can use this information to gain an understanding of how the user fits into the security system of the database.
To view a database user
To view the Windows NT groups that have access to the current database