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