How to Generate all grants to a user role? (SQL Server 2000)
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.