Re: grant select on database demo to user

Lists: pgsql-sql
From: Bryce Nesbitt <bryce1(at)obviously(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: grant select on database demo to user
Date: 2006-05-03 03:32:54
Message-ID: 44582466.7010303@obviously.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-sql

I find myself with long lists of tables

grant select on xx_tax to user;
grant select on xx_trip to user;
grant select on xx_foo to user;

Is there a way to grant to all tables, with a single grant? I know how
to do it in mysql, but not postgres. As close as I get it:

#grant select on database demo to user
ERROR: invalid privilege type SELECT for database

--
----
Visit http://www.obviously.com/

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: grant select on database demo to user
Date: 2006-05-03 05:07:20
Message-ID: 20060503050720.GA26223@webserv.wug-glas.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-sql

am 02.05.2006, um 20:32:54 -0700 mailte Bryce Nesbitt folgendes:
> I find myself with long lists of tables
>
> grant select on xx_tax to user;
> grant select on xx_trip to user;
> grant select on xx_foo to user;
>
> Is there a way to grant to all tables, with a single grant? I know how

No, but you can use a little Script, please read:
http://people.planetpostgresql.org/greg/index.php?/archives/38-guid.html#extended

HTH, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47215, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===

From: Bryce Nesbitt <bryce1(at)obviously(dot)com>
To: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: grant select on database demo to user
Date: 2006-05-06 19:46:13
Message-ID: 445CFD05.5070808@obviously.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-sql

A. Kretschmer wrote:
> Is there a way to grant to all tables, with a single grant? I know how
>
>
> No, but you can use a little Script, please read:
> http://people.planetpostgresql.org/greg/index.php?/archives/38-guid.html#extended
>
> HTH, Andreas
>
Thanks,
What always happens is I create a new view, or replace an old view, and
the grant step
gets forgotten. Then I get angry users who can't see the view (I can
see it, just they can't)....
-Bryce