Is there something like a limited superuser to give to a db-assistant?

Поиск
Список
Период
Сортировка
От Andreas
Тема Is there something like a limited superuser to give to a db-assistant?
Дата
Msg-id 5269CF0C.8030208@gmx.net
обсуждение исходный текст
Ответы Re: Is there something like a limited superuser to give to a db-assistant?  ("Tomas Vondra" <tv@fuzzy.cz>)
Re: Is there something like a limited superuser to give to a db-assistant?  (Michael Paquier <michael.paquier@gmail.com>)
Список pgsql-general
Дерево обсуждения
Hi,

how can I give a db-assistant the rights to create and drop schemas, tables, views ... BUT keep him out of certain existing schemas and tables?

This position of an restricted db assistant is new for us and it wasn't considered in our access rights until now.

Our DB got a wee bit komplex with about 400 schemas and 5000 tables.
So it would get rather ugly having to alter the rights for every db-object one by one manually.

В списке pgsql-general по дате отправления:

Предыдущее
От: Andreas
Дата:
Сообщение: Need help how to manage a couple of daily DB copies.
Следующее
От: "Tomas Vondra"
Дата:
Сообщение: Re: Is there something like a limited superuser to give to a db-assistant?