Postgres Pro
Downloads
Home   >   mailing lists

GRANT SELECT ON DATABASE - Mailing list pgsql-admin

From Marc Mamin
Subject GRANT SELECT ON DATABASE
Date
Msg-id C4DAC901169B624F933534A26ED7DF31010A5288@JENMAIL01.ad.intershop.net
Whole thread Raw
List pgsql-admin
Tree view

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

pgsql-admin by date:

Previous
From: Pablo Alonso-Villaverde Roza
Date:
Subject: Re: Avoid duplicated rows when restoring data from pg_dumpall ??
Next
From: Tom Lane
Date:
Subject: Re: Partitions Table