Skip site navigation (1) Skip section navigation (2)

Re: grant select on all tables

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Andrew Borley <BORLEY(at)uk(dot)ibm(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: grant select on all tables
Date: 2005-10-25 03:26:22
Message-ID: 20051025032622.GC16642@wolff.to (view raw or flat)
Thread:
Lists: pgsql-novice
On Tue, Oct 04, 2005 at 16:00:38 +0100,
  Andrew Borley <BORLEY(at)uk(dot)ibm(dot)com> wrote:
> 
> Can you set triggers on system catalog tables?

No.

> Are there any alternative ways of doing this?

It might make things easier to use groups so that you can give access to a
group whenever creating any table and then put people in that group that
are supposed to have that access.

If you are worried about people forgetting to do this, you could write a
script that checks for tables that don't have access from that group and
that adds it if needed. You could run the script daily as part of a
cron job.

In response to

pgsql-novice by date

Next:From: Tom LaneDate: 2005-10-25 03:33:06
Subject: Re: Installation problem
Previous:From: Tom LaneDate: 2005-10-25 03:25:22
Subject: Re: bit map indexes in postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group