Posted by Mark D Powell on 04/24/07 20:04

Using SQL Server 2000 I need to extract all the grants made to a user
created role so that I can recreate the role in another version of a
database and there are more grants than I want to do by hand. Does
anyone have SQL or T-SQL to perform this task that they would be
willing to share?

I tried searching the archives but either I missed the post or what I
want isn't posted.

Thank you.

Mark D Powell

[Back to original message]