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