Re: read only connection - Mailing list pgsql-admin

From Bruno Wolff III
Subject Re: read only connection
Date
Msg-id 20031107190423.GA9940@wolff.to
Whole thread Raw
In response to Re: read only connection  (Gaetano Mendola <mendola@bigfoot.com>)
List pgsql-admin
On Fri, Nov 07, 2003 at 19:53:42 +0100,
  Gaetano Mendola <mendola@bigfoot.com> wrote:
>
> I know but is not system/tables wide.
> Each time that a table is created I shall remember
> to revoke the permission, what I was looking for
> was an option to insert into pg_hba.conf

When you create a table you have to give permission for other people to
use it at all. So just give select access instead of all access.
You can even give this to a group (or public) so that you can add more
users who should have read only access without having to change the
access rights for each table.

pgsql-admin by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: Out of buffer error
Next
From: Markus Bertheau
Date:
Subject: Re: small table occupies many relpages