Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-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

pgsql-admin by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group