Re: How to hide database structure - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: How to hide database structure
Date
Msg-id 20031224040456.GA626@wolff.to
Whole thread Raw
In response to How to hide database structure  (mydba@usa.com (Michael Gill))
Responses Re: How to hide database structure
List pgsql-general
On Mon, Dec 22, 2003 at 09:10:43 -0800,
  Michael Gill <mydba@usa.com> wrote:
> How can I hide all details from users regarding data and structure,
> limiting access to data through functions I create?
>
> I don't want a user to be able to see the structure of a table with \d
> {tablename} in psql.

Don't give them any direct access to the tables and use a security definer
function to give them indirect access.

pgsql-general by date:

Previous
From: bpalmer
Date:
Subject: Re: Mirrors that don't suck.
Next
From: Bruno Wolff III
Date:
Subject: Re: How to hide database structure