From: | Christoph Della Valle <christoph(dot)dellavalle(at)goetheanum(dot)ch> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: How to GRANT SELECT on all tables? |
Date: | 2006-02-01 06:39:52 |
Message-ID: | 43E057B8.5010307@goetheanum.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
another way is to use pgAdmin.
- right click on node 'Tables'
- choose grant wizard
the rest is self explaining ;-)
kynn(at)panix(dot)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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Christoph Della Valle | 2006-02-01 06:45:12 | Re: copy |
Previous Message | Kevin Crenshaw | 2006-01-31 22:37:21 | Re: How to GRANT SELECT on all tables? |