Re: How to GRANT SELECT on all tables?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: kynn(at)panix(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: How to GRANT SELECT on all tables?
Date: 2006-01-31 21:45:30
Message-ID: 10905.1138743930@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

<kynn(at)panix(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Kevin Crenshaw 2006-01-31 22:37:21 Re: How to GRANT SELECT on all tables?
Previous Message kynn 2006-01-31 21:10:47 How to GRANT SELECT on all tables?