Re: How to GRANT SELECT on all tables?

One way to accomplish this is to create an SQL script to grant privileges to
all of your tables one at a time.  Then you would simple have to start up a
psql session and enter: \i sqlscriptname.sql;

HTH,

Kevin



-----Original Message-----
From: pgsql-novice-owner@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org] On Behalf Of kynn@panix.com
Sent: Tuesday, January 31, 2006 4:11 PM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] How to GRANT SELECT on all tables?





Another noobish question.

I'm looking for the "moral equivalent" of the mythical

  GRANT SELECT ON TABLE * TO PUBLIC

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.

Naively, I tried the subquery approach

  GRANT SELECT
    ON TABLE (SELECT tablename FROM pg_tables WHERE schemaname='public')
    TO PUBLIC

but this failed too.

Thanks!

kj


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq