Re: grant select on all tables of a schema - Mailing list pgsql-novice

Nabil Sayegh wrote:

>Hi,
>
>is it possible to 'GRANT <WHATEVER> ON ALL TABLES' in 1 command ?
>
>I'm using 7.3.2
>
>TIA
>
>
For this case of problem, I find it great to generate scripts out of the
catalog(here for the current schema):

SELECT 'GRANT <WHATEVER> ON '||tablename||' TO <WHOEVER>;'
FROM pg_tables
WHERE
schemaname = current_schema();

This way, you can speed up such Problems a lot, and you are still flexible.
Sure, you can put this into a function as well, and run the SQL dynamically.
(But I rather have allok at the generated statements before I run them.

Cheers,
Dani