GRANT SELECT ON DATABASE

From: "Marc Mamin" <M(dot)Mamin(at)intershop(dot)de>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: GRANT SELECT ON DATABASE
Date: 2009-08-27 12:23:58
Message-ID: C4DAC901169B624F933534A26ED7DF31010A5288@JENMAIL01.ad.intershop.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

I would like to have a "view only" admin role with SELECT ONLY rights
on the whole database.

Our largest Database has more than 50'000 tables with a few hundreds
added/deleted per day...

The link in this Post leads to a php error.
http://archives.postgresql.org/pgsql-sql/2006-05/msg00023.php

Can someone points me to the script, or is there a better approach to
create such a role ?

Thanks,

Marc Mamin

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2009-08-27 14:36:59 Re: Partitions Table
Previous Message Pablo Alonso-Villaverde Roza 2009-08-27 07:05:59 Re: Avoid duplicated rows when restoring data from pg_dumpall ??