Re: select any table - Mailing list pgsql-general

From Alan Hodgson
Subject Re: select any table
Date
Msg-id 200803251018.06009@hal.medialogik.com
Whole thread Raw
In response to Re: select any table  ("Roberts, Jon" <Jon.Roberts@asurion.com>)
List pgsql-general
On Tuesday 25 March 2008, "Roberts, Jon" <Jon.Roberts@asurion.com> wrote:
> We are adding tables and schemas all of the time and we need to grant
> auditors read-only access to the database.

Make a "grant select on table to auditors;" a standard part of your table
creation process.

--
Alan

pgsql-general by date:

Previous
From: "Andrus"
Date:
Subject: Triggers are disabled after restore
Next
From: lak
Date:
Subject: Toast Table