| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-10-25 03:33:06 | Re: Installation problem |
| Previous Message | Tom Lane | 2005-10-25 03:25:22 | Re: bit map indexes in postgres |