Roles and permissions

[niall5098]

HI All,

Is there a store procedure that will list the users and permissions that user has in mssql2000.

I can view the permissions but would like to spool the permissions to text doc.

Any help would be much appreciated.

Thanks.

 

[mrdenny]

This thread thread962-1324602 should have what you are looking for.

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)

My Blog