This is the closest thing to what you want:
GRANT ALL ON table TO user;
(see http://www.postgresql.org/users-lounge/docs/7.0/user/sql-grant.htm)
Michael Fork - CCNA - MCP - A+
Network Support - Toledo Internet Access - Toledo Ohio
On Wed, 31 Jan 2001, Martin A. Marques wrote:
> El Mar 30 Ene 2001 10:08, Martin A. Marques escribi�:
> > Is there a way to grant a user with all privileges on a database? Something
> > like Informixs GRANT dba?
>
> OK, I see that no one responded (except one person how made a personal
> responce), so I'll add a bit to it.
> I seem to be aware that Postgres doesn't have a function to grant total
> access to a database, so is it posible to have this added to the todo list
> for further versions? Or is it posible to build a user-function that will let
> me do this:
>
> postgres@ultra3:~ > psql horde
>
> horde=# CREATE DATABASE test;
> CREATE DATABASE
> horde=# GRANT dba TO martin; -- here is the grant issue.
> GRANT
> horde=# \c test martin;
> You are now connected to database test as user martin.
> test=# CREATE TABLE (aid SERIAL, texto TEXT);
> CREATE TABLE
> test=#
>
> Saludos... ;-)
>
>
> --
> 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
> -----------------------------------------------------------------
>