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?

-- Mark D Powell --

• Next in forum: Database Mail: detecting undeliverable from Exchange?
• Prev in forum: Re: Upgrade
• Thread view: How to Generate all grants to a user role? (SQL Server 2000)

[Reply to this message]