Re: [SQL] grant select on database demo to user

2006-05-06 Thread Bryce Nesbitt
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

Re: [SQL] grant select on database demo to user

2006-05-02 Thread A. Kretschmer
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 N

Re: [SQL] grant select on database demo to user

2006-05-02 Thread Thusitha Kodikara
PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bryce Nesbitt Sent: Wednesday, May 03, 2006 9:03 AM To: pgsql-sql@postgresql.org Subject: [SQL] 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;   gr

[SQL] grant select on database demo to user

2006-05-02 Thread Bryce Nesbitt
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 data