Re: [Emerald] Script to set permissions...

Dale E. Reed Jr. ( (no email) )
Wed, 02 Feb 2000 16:01:47 -0800

Nathan Haywood wrote:
>
> That's great for adding permissions, but apparently some of our tables have
> too many "GRANTS"... Is there any trick in SQL 7.0 to just drop all
> permissions (other than dbo/sa) on everything in a Database?

Maybe drop the groups and re-create them?

-- 

Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com

For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart