X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 194C99FA60C for ; Fri, 21 Jul 2006 12:52:50 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 69550-02-2 for ; Fri, 21 Jul 2006 12:52:41 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id DAEC29FA3B4 for ; Fri, 21 Jul 2006 11:47:17 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k6LEl8c4022471; Fri, 21 Jul 2006 10:47:09 -0400 (EDT) To: Hilary Forbes cc: pgsql-sql@postgresql.org Subject: Re: System catalog table privileges In-reply-to: <5.1.0.14.0.20060721133547.040c0e28@mailserver.dmr.co.uk> References: <5.1.0.14.0.20060721133547.040c0e28@mailserver.dmr.co.uk> Comments: In-reply-to Hilary Forbes message dated "Fri, 21 Jul 2006 13:45:16 +0100" Date: Fri, 21 Jul 2006 10:47:08 -0400 Message-ID: <22470.1153493228@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.074 tagged_above=0 required=5 tests=AWL, SPF_HELO_PASS, SPF_PASS X-Spam-Level: X-Archive-Number: 200607/278 X-Sequence-Number: 25852 Hilary Forbes writes: > Next question on privileges!  Can I safely remove all privileges > from the system catalog tables for a user Various people have experimented with doing that, but it tends to break a lot of stuff. I suggest you just revoke privileges on the tables you don't want the users messing with, and not get too worried about whether they know the tables exist or not. regards, tom lane