| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Michael Fuhr <mike(at)fuhr(dot)org> |
| Cc: | Andrus <noeetasoftspam(at)online(dot)ee>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Hot to restrict access to subset of data |
| Date: | 2005-07-01 16:08:46 |
| Message-ID: | 20050701160846.GB19934@wolff.to |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Jul 01, 2005 at 08:46:04 -0600,
Michael Fuhr <mike(at)fuhr(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrus | 2005-07-01 18:43:34 | Re: Hot to restrict access to subset of data |
| Previous Message | MargaretGillon | 2005-07-01 16:04:27 | Re: How to know if a TRANSACTION isn't completed |