Обсуждение: PostgreSQL: ´GRANT ALL TO PUBLIC´ ?

Поиск
Список
Период
Сортировка

PostgreSQL: ´GRANT ALL TO PUBLIC´ ?

От
"Dr. Roger Wießner"
Дата:
Hallo!

Is there a way to �GRANT ALL TO PUBLIC�?
(All tables, sequences and indexes at once?)

Or: Can one map all users to user �postgres�?


Thank you!
Roger

Re: PostgreSQL: ´GRANT AL

От
Bruno Wolff III
Дата:
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.