Postgres Pro
Downloads
Home   >   mailing lists

Re: How to GRANT SELECT on all tables? - Mailing list pgsql-novice

From Tom Lane
Subject Re: How to GRANT SELECT on all tables?
Date
Msg-id 10905.1138743930@sss.pgh.pa.us
Whole thread Raw
In response to How to GRANT SELECT on all tables?  (<kynn@panix.com>)
List pgsql-novice
Tree view 
<kynn@panix.com> writes:
> I.e. I'm looking for a way to grant SELECT privileges to PUBLIC on all
> the tables, without having to specify all the table names.

There isn't any direct way to do that, but various people have written
plpgsql functions that synthesize and execute all the required
individual GRANT commands.  Dig around in the PG list archives ...
http://archives.postgresql.org/

            regards, tom lane

pgsql-novice by date:

Previous
From:
Date:
Subject: How to GRANT SELECT on all tables?
Next
From: "Kevin Crenshaw"
Date:
Subject: Re: How to GRANT SELECT on all tables?