Query to audit users having access to SQL DB 2005

[gauravdubey80]

Hi I want to write a query to extract all the unique names having access to the SQL DB from the master Db.
ANy ideas? Ready Queries?

 

[mrdenny]

Select from the sysusers table in SQL 2000 or the sys.database_principals in SQL 2005 from within the database in question.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com