Re: GRANT SELECT

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Stephen Crawford <src176(at)psu(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: GRANT SELECT
Date: 2012-08-27 17:35:55
Message-ID: CAFj8pRAAYeM=B+fH3k6dBqkQxS-A1UKPPNw5ZxcU_JnbFNaN6g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2012/8/27 Stephen Crawford <src176(at)psu(dot)edu>:
> 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:
>

just don't use "format" function

execure 'grant select on ' || tn || 'to ....';

>
> 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2012-08-27 20:23:00 Re: [GENERAL] Why extract( ... from timestamp ) is not immutable?
Previous Message Stephen Crawford 2012-08-27 17:32:16 Re: GRANT SELECT