Re: grant a db

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(at)ontko(dot)com>
To: "Martin A. Marques" <martin(at)math(dot)unl(dot)edu(dot)ar>
Cc: "pgsql-general" <pgsql-general(at)postgresql(dot)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(at)ontko(dot)com Phone 1.765.935.4283 Fax 1.765.962.9788
> Ray Ontko & Co. Software Consulting Services http://www.ontko.com/
>
> Personal:
> nickf(at)fankhausers(dot)com http://www.fankhausers.com
>
>
>
>
> > -----Original Message-----
> > From: pgsql-general-owner(at)postgresql(dot)org
> > [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Martin A.
> > Marques
> > Sent: Tuesday, December 19, 2000 8:20 AM
> > To: pgsql-general(at)postgresql(dot)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(at)math(dot)unl(dot)edu(dot)ar
> > Santa Fe - Argentina http://math.unl.edu.ar/~martin/
> > Administrador de sistemas en math.unl.edu.ar
> > -----------------------------------------------------------------
> >