Re: [GENERAL] How to Prevent Certain Kinds of Joins?

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Heather Johnson <hjohnson(at)nypost(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] How to Prevent Certain Kinds of Joins?
Date: 2005-02-22 20:09:15
Message-ID: 20050222200915.GA71591@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

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/

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Heather Johnson 2005-02-22 20:30:44 Re: [GENERAL] How to Prevent Certain Kinds of Joins?
Previous Message Richard Huxton 2005-02-22 20:08:09 Re: [GENERAL] How to Prevent Certain Kinds of Joins?

Browse pgsql-general by date

  From Date Subject
Next Message Heather Johnson 2005-02-22 20:30:44 Re: [GENERAL] How to Prevent Certain Kinds of Joins?
Previous Message Richard Huxton 2005-02-22 20:08:09 Re: [GENERAL] How to Prevent Certain Kinds of Joins?