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

--
ElEucas
México

---

View this message in context: Re: GRANT SELECT
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

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