Postgres Pro
Downloads
Home   >   mailing lists

Re: Grant read-only access to exactly one database amongst many - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: Grant read-only access to exactly one database amongst many
Date
Msg-id CAKFQuwZiHFtQMtD8CWiF1O-Kz8WUyZrS9CXPy4ZS18x6nQ3GsQ@mail.gmail.com
Whole thread Raw
In response to Re: Grant read-only access to exactly one database amongst many  (Graham Leggett <minfrin@sharp.fm>)
List pgsql-hackers
Tree view
On Monday, February 5, 2024, Graham Leggett <minfrin@sharp.fm> wrote:

Also, how do you handle the race condition between the time a database db3 is created, and the the time all readonly users have their access revoked to db3?


You alter the default privileges for the system so PUBLIC does not get connect privileges on newly created databases.

David J.

p.s. this mailing list is for discussing patches, discussions Lon how to use the system belong on the -general list.

pgsql-hackers by date:

Previous
From: Jim Jones
Date:
Subject: Re: Patch: Add parse_type Function
Next
From: "David E. Wheeler"
Date:
Subject: Re: Patch: Add parse_type Function