| From: | "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org> |
|---|---|
| To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
| Cc: | "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: REVOKE from all tables ... |
| Date: | 2005-08-09 05:20:17 |
| Message-ID: | 20050809021939.J1002@ganymede.hub.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)hub(dot)org Yahoo!: yscrappy ICQ: 7615664
| From | Date | Subject | |
|---|---|---|---|
| Next Message | josh@segrestfarms.com | 2005-08-09 12:36:57 | SQL Server 2000 to PostgreSQL 8.0.3 |
| Previous Message | Joshua D. Drake | 2005-08-09 04:45:42 | Re: REVOKE from all tables ... |