Just recently added this functionality to phpPgAdmin. You can now update
the ACL of all the objects (tables, sequences, views) of a database at the
same time.
This will be part of the next release (2.2.1) which should happen this week
sometime. Look for the announcement.
-Dan
----- Original Message -----
From: "Nick Fankhauser" <nickf@ontko.com>
To: "Martin A. Marques" <martin@math.unl.edu.ar>
Cc: "pgsql-general" <pgsql-general@postgresql.org>
Sent: Tuesday, December 19, 2000 5:29 AM
Subject: RE: [GENERAL] grant a db
> I believe it has to be each table- Oracle has a nice "all tables" option
> which might be worth the developer's consideration on the next round. I
need
> to do this regularly, so I'll probably see if I can write a tool to create
a
> SQL script. I'll let you know when I get it done.
>
> -Nick
>
> ---------------------------------------------------------------------
> Nick Fankhauser
>
> Business:
> nickf@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788
> Ray Ontko & Co. Software Consulting Services http://www.ontko.com/
>
> Personal:
> nickf@fankhausers.com http://www.fankhausers.com
>
>
>
>
> > -----Original Message-----
> > From: pgsql-general-owner@postgresql.org
> > [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Martin A.
> > Marques
> > Sent: Tuesday, December 19, 2000 8:20 AM
> > To: pgsql-general@postgresql.org
> > Subject: [GENERAL] grant a db
> >
> >
> > Maybe I'm confused, but can I GRANT a user with ALL privileges on
> > a database,
> > or does it have to do it on each table?
> >
> > --
> > System Administration: It's a dirty job,
> > but someone told I had to do it.
> > -----------------------------------------------------------------
> > Martín Marqués email: martin@math.unl.edu.ar
> > Santa Fe - Argentina http://math.unl.edu.ar/~martin/
> > Administrador de sistemas en math.unl.edu.ar
> > -----------------------------------------------------------------
> >