Re: GRANT SELECT

I see that works for 9, but I'm still in 8.4. But another person just
sent me a bit of code to do it:

do $$
declare tn text;
begin
for tn in select c.oid::regclass::text
from pg_class c join pg_namespace n on n.oid = c.relnamespace
where n.nspname not in ('pg_catalog',
'information_schema') and n.nspname !~ '^pg_toast' and c.relkind in
('r','')
loop
execute format('grant select on %s to your_user', tn);
end loop;
end;
$$ ;

Thanks,
Steve

On 8/27/2012 1:20 PM, ElEucas wrote:
> *GRANT *{ { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES
> | TRIGGER } [, ...] | ALL [ PRIVILEGES ] } ON { [ TABLE ] table_name
> [, ...] | *ALL TABLES IN SCHEMA schema_name *[, ...] } TO { [ GROUP ]
> role_name | PUBLIC } [, ...] [ WITH GRANT OPTION ] See more on
> PostgreSQL Documentation
> <http://www.postgresql.org/docs/9.1/static/sql-grant.html>
> --
> ElEucas
> México
>
> ------------------------------------------------------------------------
> View this message in context: Re: GRANT SELECT
> <http://postgresql.1045698.n5.nabble.com/GRANT-SELECT-tp5721395p5721400.html>
> Sent from the PostgreSQL - general mailing list archive
> <http://postgresql.1045698.n5.nabble.com/PostgreSQL-general-f1843780.html>
> at Nabble.com.

--
Stephen Crawford
Center for Environmental Informatics
The Pennsylvania State University