Re: Hot to restrict access to subset of data - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Hot to restrict access to subset of data
Date
Msg-id 20050701160846.GB19934@wolff.to
Whole thread Raw
In response to Re: Hot to restrict access to subset of data  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
On Fri, Jul 01, 2005 at 08:46:04 -0600,
  Michael Fuhr <mike@fuhr.org> wrote:
> On Fri, Jul 01, 2005 at 01:56:41PM +0300, Andrus wrote:
>
> > 2. Postgres should allow access from my application only. Is it possible to
> > use authentication method which allows access from my application only ?
>
> You could have the application connect to the database as a particular
> user and grant permissions on the table only to that user.

Note, that will not put much of a hurdle in front of people who are running
the application on a machine they have physical access to. So that may
not be an acceptible solution for you.

pgsql-general by date:

Previous
From: Matt Miller
Date:
Subject: Re: Sizes
Next
From: MargaretGillon@chromalloy.com
Date:
Subject: Re: How to know if a TRANSACTION isn't completed