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
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 -Original Message- From: [EMAIL PROTECTED] [mailto