Re: Restrict users from describing table - Mailing list pgsql-hackers

From Bruno Wolff III
Subject Re: Restrict users from describing table
Date
Msg-id 20040109041035.GA31586@wolff.to
Whole thread Raw
In response to Re: Restrict users from describing table  (Michael Gill <mgill@pointdx.com>)
Responses Re: Restrict users from describing table
List pgsql-hackers
On Mon, Jan 05, 2004 at 11:32:42 +0500, Michael Gill <mgill@pointdx.com> wrote:
> 
> I think I have found the simple solution by separating the user from the 
> owner of the tables, however!
> 
> I have simply created tables and functions in the owner's schema(A), 
> then granted execution to the other user(B). My brief testing indicates 
> that B cannot access or describe A's objects, yet can execute the 
> function that retrieves data and returns a ref cursor.
> 

This won't work as they can still get at the system catalog which will
allow them to see the schema.


pgsql-hackers by date:

Previous
From: Rod Taylor
Date:
Subject: Re: psql \d option list overloaded
Next
From: Tom Lane
Date:
Subject: Re: How to retrieve functional index column names