Postgres Pro
Downloads
Home   >   mailing lists

Re: grant select on database demo to user - Mailing list pgsql-sql

From A. Kretschmer
Subject Re: grant select on database demo to user
Date
Msg-id 20060503050720.GA26223@webserv.wug-glas.de
Whole thread Raw
In response to grant select on database demo to user  (Bryce Nesbitt <bryce1@obviously.com>)
Responses Re: grant select on database demo to user
List pgsql-sql
Tree view 
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    ===

pgsql-sql by date:

Previous
From: "Ben K."
Date:
Subject: Re: Sorting aggregate column contents
Next
From: "Catalin Pitis"
Date:
Subject: Re: ERROR: plan should not reference subplan's variable