Friday, February 20, 2009

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,
out put of this stored procedure will be
UserName, GroupName, LoginName, DefDBName, UserID, SID

No comments: