SQL Query to list all Users or Login Names from the database

This will be very useful when you want to know who all are having access to the database.
Execute the below stored procedure,

sp_helpuser 

out put of this stored procedure will be
UserName, GroupName, LoginName, DefDBName, UserID, SID