Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

Next:From: Alvaro HerreraDate: 2005-03-27 16:06:47
Subject: Re: Import Database
Previous:From: Bruno Wolff IIIDate: 2005-03-27 15:47:56
Subject: Re: grant problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group