Обсуждение: grant select on database demo to user

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/

Hi,

You could easily generate a script with the list of tables and the required grant information and then run it to give the necessary grants. (The list of tables may be obtained by querying tables in 'information_schema')

Regards,
-Thusitha

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

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