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 === ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
