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
