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

Nathan Haywood ( nhaywood@whro.org )
Wed, 2 Feb 2000 15:59:19 -0500

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?

-----Original Message-----
From: Dale E. Reed Jr. [mailto:daler@iea-software.com]
Sent: Wednesday, February 02, 2000 3:56 PM
To: emerald@iea-software.com
Subject: Re: [Emerald] Script to set permissions...

Nathan Haywood wrote:
>
> OK, we've been running Emerald since 2.1 was new... Apparently, or SQL
> tables/views don't have the correct permissions. Is there any chance of
> getting an SQL script that would just drop and reapply permissions to all
> the tables/views/procs currently used by Emerald?

Yes. instperm.sql will modify the permissions for you.

-- 

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

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