How to Select Permissions for User Defined Database Role?

[JohnBates]

hi all,

This is SQL Server 2000.
I know in 2000 there are a few tables to pull from to get the permissions for a user-defined database role.

This is what the auditors have requested.

Does anyone have some code that will do this?

Thanks, John

 

[mrdenny]

This thread should do the trick thread962-1324602.

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