Reply to How to Generate all grants to a user role? (SQL Server 2000)
Posted by Mark D Powell on 04/25/07 20:19
I had thought that I had posted this yesterday but since I cannot find
it here we go again.
I have searched the archives but either the code I want is not posted
or I missed it.
I have a user create role in a database that I need to reproduce in
another version of the database. Does anyone out there have the SQL
or T-SQL necessary to generate all the grants to a role?