Path: utzoo!utgpu!news-server.csri.toronto.edu!mailrus!wuarchive!uunet!tiamat!jim
From: jim@tiamat.fsc.com (Jim O'Connor)
Newsgroups: comp.databases
Subject: Revoking privileges across the board
Message-ID: <767@tiamat.fsc.com>
Date: 28 Aug 90 13:57:40 GMT
Organization: Ahlstrom Filtration - Chattanooga,TN
Lines: 20

Using Informix-SQL I can issue the statements

grant select on table1 to user1, user2, user3;
grant select on table1 to user2, user2, user3;
grant insert, update on table1 to user1;
grant insert, update, delete on table2 to user2, user3;

to grant selected privileges to individual users.

Is there any way to remove all of these granted privileges with
one statement?  That is, I'd like to be able to issue one statement
and know that I've wiped out all priviliges that have ever been granted to
any user.  Is it safe to tinker with the sys table that has the privilege
data in it directly?  For example, "delete from systabauth;" and "delete
from syscolauth;".

Thanks for any suggestion you may have.
------------- 
James B. O'Connor			jim@tiamat.fsc.com
Ahlstrom Filtration, Inc.		615/821-4022 x. 651