Re: REVOKE from all tables ... - Mailing list pgsql-admin

From Marc G. Fournier
Subject Re: REVOKE from all tables ...
Date
Msg-id 20050809021939.J1002@ganymede.hub.org
Whole thread Raw
In response to Re: REVOKE from all tables ...  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-admin
On Mon, 8 Aug 2005, Joshua D. Drake wrote:

> Marc G. Fournier wrote:
>
>>
>> Is there a way of REVOKEing privileges on all tables in a database?  I've
>> checked the REVOKE man page, and there doesn't appear to be, but I figured
>> I'd double check to make sure ...
>
> No. This has actually been a requested feature on the grant side as well...
> Nothing a simple for loop can't do with perl though.

Ya, that is what I did, it just seemed that there should be a much
simplier way of doing it :(  Ah well, at least I wasn't re-creating the
wheel on this one :)

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664

pgsql-admin by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: REVOKE from all tables ...
Next
From: "josh@segrestfarms.com"
Date:
Subject: SQL Server 2000 to PostgreSQL 8.0.3