Restricting the CREATEROLE privilege

Поиск
Список
Период
Сортировка
От Wappler, Robert
Тема Restricting the CREATEROLE privilege
Дата
Msg-id C8E2DAF0E663A948840B04023E0DE32A0260B5D4@w2k3server02.de.ophardt.com
обсуждение исходный текст
Ответы Re: Restricting the CREATEROLE privilege  (Alex Hunsaker <badalex@gmail.com>)
Список pgsql-general
Good Morning,
is there a way to limit the CREATEROLE privilege to a specific database?
I currently set up an automated integration test environment. This includes a
database owned by a specific user which should have all degrees of freedom
for installing whatever database schemas are in the current revision as well as
creating roles used by the test cases to access the database.

I do not want that user to create roles, which are then available in every
database.

--

    Robert...



 


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

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Performance comparison
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: Performance comparison