Re: PostgreSQL: ´GRANT AL

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Dr(dot) Roger Wießner <wiessner(at)confluenta(dot)de>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: PostgreSQL: ´GRANT AL
Date: 2005-03-27 15:50:26
Message-ID: 20050327155026.GC9280@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, Mar 23, 2005 at 16:20:03 +0100,
"Dr. Roger Wießner" <wiessner(at)confluenta(dot)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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Alvaro Herrera 2005-03-27 16:06:47 Re: Import Database
Previous Message Bruno Wolff III 2005-03-27 15:47:56 Re: grant problem