Postgres Pro
Downloads
Home   >   mailing lists

Restrict user to create only one db with a specific name - Mailing list pgsql-general

From Tiffany Thang
Subject Restrict user to create only one db with a specific name
Date
Msg-id CAB_W-NNf3RUDHOMPOvYhyTTdrbYE5pEQp72f9GZLJSB13f--7Q@mail.gmail.com
Whole thread Raw
Responses Re: Restrict user to create only one db with a specific name  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: Restrict user to create only one db with a specific name  (Paul Förster <paul.foerster@gmail.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: Dmitry Igrishin
Date:
Subject: Re: libpq and escaping array string literals
Next
From: "David G. Johnston"
Date:
Subject: Re: Restrict user to create only one db with a specific name