Re: Grant read-only access to exactly one database amongst many

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Graham Leggett <minfrin(at)sharp(dot)fm>
Cc: "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Grant read-only access to exactly one database amongst many
Date: 2024-02-05 14:59:27
Message-ID: CAKFQuwZiHFtQMtD8CWiF1O-Kz8WUyZrS9CXPy4ZS18x6nQ3GsQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Monday, February 5, 2024, Graham Leggett <minfrin(at)sharp(dot)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.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message David E. Wheeler 2024-02-05 15:14:00 Re: Patch: Add parse_type Function
Previous Message Jim Jones 2024-02-05 14:49:29 Re: Patch: Add parse_type Function