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