Received: from styx.apartia.ch (APoncelet-101-2-1-171.abo.wanadoo.fr [193.251.42.171]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f38AR4870269 for ; Sun, 8 Apr 2001 06:27:40 -0400 (EDT) (envelope-from vindex@apartia.ch) Received: by styx.apartia.ch (Postfix, from userid 1000) id 582EF162; Sun, 8 Apr 2001 11:10:06 +0200 (CEST) Date: Sun, 8 Apr 2001 11:10:06 +0200 From: Louis-David Mitterrand To: pgsql-sql@postgresql.org Subject: Re: [GENERAL] Re: Permissons on database Message-ID: <20010408111006.A488@apartia.ch> Mail-Followup-To: pgsql-sql@postgresql.org References: <3AA517BE.31EEE461@inet-interactif.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.3.17i In-Reply-To: ; from roland@astrofoto.org on Wed, Mar 07, 2001 at 03:40:44PM -0500 X-Archive-Number: 200104/111 X-Sequence-Number: 2457 On Wed, Mar 07, 2001 at 03:40:44PM -0500, Roland Roberts wrote: > >>>>> "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 A simple two-line shell script to apply any command to a list of tables: for i in `psql mydatabase -c '\dt' -P tuples_only | cut -f2 -d ' '` do psql mydatabase -c "grant all on $i to public"; done > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://www.postgresql.org/search.mpl These mailing list footers really suck. Please consider removing them. They reflect poorly on the general level of the pgsql-* lists. Instead do send a one-time "welcome" message containing all your "tips" when people subscribe to a list. Probably a lost cause but the subject mangling [GENERAL], [HACKERS] etc. (especially that one! a "hacker" should know how to filter his mail) really sucks too. Educate, don't stoop. Even Outlook Express has great filtering capabilities which don't require any subject mangling. -- slashdot: I miss my free time, Rob.