From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
---|---|
To: | Michael Gill <mydba(at)usa(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: How to hide database structure |
Date: | 2003-12-24 04:08:32 |
Message-ID: | 20031224040832.GC626@wolff.to |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Dec 23, 2003 at 22:04:56 -0600,
Bruno Wolff III <bruno(at)wolff(dot)to> wrote:
> 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.
I made a mistake. The above only limits access to the data. You can't
limit access to the structure while allowing direct access to the database.
You will need to create a proxy application/server if you want to do this.
From | Date | Subject | |
---|---|---|---|
Next Message | Ezra Epstein | 2003-12-24 04:30:48 | Re: Tables Referencing themselves As Foreign Keys |
Previous Message | Bruno Wolff III | 2003-12-24 04:04:56 | Re: How to hide database structure |