Received: from www-uk-05.digiserve.com ([195.172.23.63]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f26HYWx43583; Tue, 6 Mar 2001 12:34:32 -0500 (EST) (envelope-from dev@archonet.com) Received: from mainbox.archonet.com (mwynhau.demon.co.uk [193.237.186.96]) by www-uk-05.digiserve.com (8.9.1/8.9.1) with ESMTP id RAA16249; Tue, 6 Mar 2001 17:35:36 GMT Received: from client.archonet.com (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with SMTP id 738CC2A475; Tue, 6 Mar 2001 17:26:13 +0000 (GMT) From: dev@archonet.com Date: Tue, 06 Mar 2001 17:26:12 GMT Message-ID: <20010306.17261200@client.archonet.com> Subject: Re: [SQL] Permissons on database To: Boulat Khakimov Cc: pgsql-sql@postgresql.org, pgsql-general@postgresql.org, pgsql-novice@postgresql.org Reply-To: dev@archonet.com In-Reply-To: <3AA517BE.31EEE461@inet-interactif.com> References: <3AA517BE.31EEE461@inet-interactif.com> X-Mailer: Mozilla/3.0 (compatible; StarOffice/5.2;Linux) X-Priority: 3 (Normal) MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by mail.postgresql.org id f26HYXx43587 X-Archive-Number: 200103/268 X-Sequence-Number: 5751 On 3/6/01, 5:00:47 PM, Boulat Khakimov wrote regarding [SQL] Permissons on database: > Hi, > How do I grant permissions on everything in the selected databes? > GRANT doesnt take as on object database name nor does it accept wild > chars.... By hand at the moment I'm afraid. There is no GRANT ALL ON ALL... Having said that, if you have plpgsql enabled on that database you could write a simple loop to do so for you. If you'd find one useful let me know and I'll knock one up. - Richard Huxton