Restrict user to create only one db with a specific name

Поиск
Список
Период
Сортировка
От Tiffany Thang
Тема Restrict user to create only one db with a specific name
Дата
Msg-id CAB_W-NNf3RUDHOMPOvYhyTTdrbYE5pEQp72f9GZLJSB13f--7Q@mail.gmail.com
обсуждение исходный текст
Ответы Re: Restrict user to create only one db with a specific name
Re: Restrict user to create only one db with a specific name
Список pgsql-general
Hi,
Is there a way in PostgreSQL 12 to restrict user to creating a database with a specific database name?

For example, userA can only create a database with a name called mydb. Any other names would generate an error. 

If that is not possible, will it be possible then to limit userA to creating only one database? Granting the createdb privilege would allow the user to create any  number of databases which I want to avoid.

Thanks.

Tiff

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

Предыдущее
От: Dmitry Igrishin
Дата:
Сообщение: Re: libpq and escaping array string literals
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Restrict user to create only one db with a specific name