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
> -----------------------------------------------------------------
>