Re: Change onership of database and all tables? (fwd) - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Change onership of database and all tables? (fwd)
Date
Msg-id 20031229042111.GB4924@wolff.to
Whole thread Raw
In response to Re: Change onership of database and all tables? (fwd)  (Russ Schneider <russ@sugapablo.com>)
List pgsql-general
On Sun, Dec 28, 2003 at 20:50:47 -0500,
  Russ Schneider <russ@sugapablo.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.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_recvbuf errors
Next
From: CSN
Date:
Subject: phppgadmin, pkey's and indexes