Received: from racerx.cabrion.com (racerx.cabrion.com [166.82.231.4]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f2D2Kqx23852; Mon, 12 Mar 2001 21:20:52 -0500 (EST) (envelope-from rob@cabrion.com) Received: from home (gso163-25-240.triad.rr.com [24.163.25.240]) by racerx.cabrion.com (8.11.0/8.11.0) with SMTP id f2D2KhU04689; Mon, 12 Mar 2001 21:20:44 -0500 Message-ID: <004a01c0ab64$2e237990$4200fd0a@home> From: "Rob Arnold" To: , , , "Roland Roberts" References: <3AA517BE.31EEE461@inet-interactif.com> Subject: Re: [SQL] Permissons on database Date: Mon, 12 Mar 2001 21:20:27 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200103/552 X-Sequence-Number: 6051 Are you looking for "grant all to public" or "grant select to public"? ----- Original Message ----- From: "Roland Roberts" To: ; ; Sent: Wednesday, March 07, 2001 3:40 PM Subject: Re: [SQL] Permissons on database > >>>>> "bk" == Boulat Khakimov writes: > > bk> How do I grant permissions on everything in the selected > bk> databes? > > bk> GRANT doesnt take as on object database name nor does it > bk> accept wild chars.... > > Attached is some Perl code I wrote long ago to do this. This > particular code was done for Keystone, a problem tracking database and > it would do a "GRANT ALL". Modify it as needed. Last I checked it > worked with both PostgreSQL 6.5.x and 7.0.x > > ---------------------------------------------------------------------------- ---- > > roland > -- > PGP Key ID: 66 BC 3B CD > Roland B. Roberts, PhD RL Enterprises > roland@rlenter.com 76-15 113th Street, Apt 3B > rbroberts@acm.org Forest Hills, NY 11375 >