Re: How to GRANT SELECT on all tables?

another way is to use pgAdmin.

- right click on node 'Tables'
- choose grant wizard
the rest is self explaining ;-)

kynn@panix.com schrieb:
> 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
>
>