Re: Change onership of database and all tables? (fwd)

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Russ Schneider <russ(at)sugapablo(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Change onership of database and all tables? (fwd)
Date: 2003-12-29 04:21:11
Message-ID: 20031229042111.GB4924@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, Dec 28, 2003 at 20:50:47 -0500,
Russ Schneider <russ(at)sugapablo(dot)com> wrote:
>
> Or if no one can answer the above question, what about a way to grant
> permissions on more than one table at a time? Like GRANT ALL PRIVILEGES
> ON [ALL TABLES] TO [USER]?

You can do this with a script that gets the names of all of the tables
and then does a grant on each one.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message krishna kumar 2003-12-29 06:00:43 Filter usage
Previous Message Tom Lane 2003-12-29 04:19:32 Re: pg_recvbuf errors