Re: How to hide database structure

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Michael Gill <mydba(at)usa(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to hide database structure
Date: 2003-12-24 04:04:56
Message-ID: 20031224040456.GA626@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Dec 22, 2003 at 09:10:43 -0800,
Michael Gill <mydba(at)usa(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2003-12-24 04:08:32 Re: How to hide database structure
Previous Message Lynn.Tilby 2003-12-24 02:26:14 Installing Postgres w/RH9