Script for revoking

From: Stephen Mulcahy <smulcahy_at_smsat.ilo.dec.com>
Date: 4 Jun 1998 17:56:03 GMT
Message-ID: <6l6n3j$qt5$1@mrnews.mro.dec.com>

Hi,

I'm trying to figure out how to automate some of our privilege granting procedures by turning them into sql scripts .. for instance, I have a user in the database who owns a bunch of tables. If I want to set permissions on this users tables to a known state I have to run a scrip of the form ..

revoke all on tablefoo from otheruser;
...

for each table/user in the database ideally (just to be sure .. is this being excessively paranoid?). At the moment I build up a list of these revokes by doing selects from the data dictionaries, spooling the results to a file and editing the file into the above format.

What I'd like to is create a procedure or set of procedure which will automatically build up this list and optionally do the revoking. What I'm not clear on is how to mix commands like revoke with sql type commands .. is it even possible?

Thanks for any advice,

-stephen

---

Stephen Mulcahy, Digital Equipment International, smulcahy_at_smsat.ilo.dec.com The views expressed are the author's and do not necessarily reflect the official position of Digital Equipment Corporation Received on Thu Jun 04 1998 - 12:56:03 CDT