Re: PostgreSQL: ´GRANT AL - Mailing list pgsql-admin

From Bruno Wolff III
Subject Re: PostgreSQL: ´GRANT AL
Date
Msg-id 20050327155026.GC9280@wolff.to
Whole thread Raw
In response to PostgreSQL: ´GRANT ALL TO PUBLIC´ ?  ("Dr. Roger Wießner" <wiessner@confluenta.de>)
List pgsql-admin
On Wed, Mar 23, 2005 at 16:20:03 +0100,
  "Dr. Roger Wießner" <wiessner@confluenta.de> wrote:
> Hallo!
>
> Is there a way to ´GRANT ALL TO PUBLIC´?
> (All tables, sequences and indexes at once?)

You can write a script to do it. I believe examples have posted previously
and are in the archives.

> Or: Can one map all users to user ´postgres´?

You can use groups to do something like this.


pgsql-admin by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: grant problem
Next
From: Bruno Wolff III
Date:
Subject: Re: ´Stalled post to pgsq