X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6AC8B8B9D1E; Tue, 22 Feb 2005 20:09:31 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 93268-05; Tue, 22 Feb 2005 20:09:20 +0000 (GMT) Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by svr1.postgresql.org (Postfix) with ESMTP id 4738E8B9B44; Tue, 22 Feb 2005 20:09:20 +0000 (GMT) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.1/8.13.1) with ESMTP id j1MK9Fda038099 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Tue, 22 Feb 2005 13:09:18 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.1/8.13.1) with ESMTP id j1MK9FxY071649; Tue, 22 Feb 2005 13:09:15 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.1/8.13.1/Submit) id j1MK9F49071648; Tue, 22 Feb 2005 13:09:15 -0700 (MST) (envelope-from mfuhr) Date: Tue, 22 Feb 2005 13:09:15 -0700 From: Michael Fuhr To: Heather Johnson Cc: pgsql-admin@postgresql.org, pgsql-general@postgresql.org Subject: Re: [GENERAL] How to Prevent Certain Kinds of Joins? Message-ID: <20050222200915.GA71591@winnie.fuhr.org> References: <421B8D2D.6050800@nypost.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <421B8D2D.6050800@nypost.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.003 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/233 X-Sequence-Number: 16401 On Tue, Feb 22, 2005 at 02:51:09PM -0500, Heather Johnson wrote: > Is there a way to revoke permission to join two or more tables, even for > users who have all other permissions (e.g., select, insert, update, > delete) on those tables? For what purpose? If this were possible, then users could still do joins on the client side if they had access to all the data. Are you just trying to prevent potentially large queries? What problem are you trying to solve? -- Michael Fuhr http://www.fuhr.org/~mfuhr/