Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 1491B474E5C for ; Mon, 9 Dec 2002 11:42:06 -0500 (EST) Received: from anchor-post-33.mail.demon.net (anchor-post-33.mail.demon.net [194.217.242.91]) by postgresql.org (Postfix) with ESMTP id 25761476454 for ; Mon, 9 Dec 2002 11:28:35 -0500 (EST) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-33.mail.demon.net with esmtp (Exim 3.35 #1) id 18LQlq-000BhQ-0X; Mon, 09 Dec 2002 16:28:38 +0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by mainbox.archonet.com (Postfix) with ESMTP id 249E6161FC; Mon, 9 Dec 2002 16:28:37 +0000 (GMT) Received: from client.archonet.com (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with ESMTP id 8B321161F7; Mon, 9 Dec 2002 16:28:36 +0000 (GMT) Content-Type: text/plain; charset="iso-8859-1" From: Richard Huxton Organization: Archonet Ltd To: Michael Weaver , "'pgsql-sql@postgresql.org'" Subject: Re: Default Permissions (repost from Novice) Date: Mon, 9 Dec 2002 16:28:32 +0000 User-Agent: KMail/1.4.3 References: <3B663B41B350D311AEEF00A0C9254563201A26@VISION1> In-Reply-To: <3B663B41B350D311AEEF00A0C9254563201A26@VISION1> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200212091628.33041.dev@archonet.com> X-Virus-Scanned: by AMaViS snapshot-20020531 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200212/100 X-Sequence-Number: 10688 On Monday 09 Dec 2002 6:51 am, Michael Weaver wrote: > How can I set default permissions on tables, so that I don't have to > manually set them for every table? Don't know if you got an answer in novice, but your best bet is one of the= =20 GRANT ... TO ALL type solutions mentioned in the last week or so. See my=20 PostgreSQL Notes linked to from http://techdocs.postgresql.org --=20 Richard Huxton