Re: grant connect to all databases

From: Matt Zagrabelny <mzagrabe(at)d(dot)umn(dot)edu>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: grant connect to all databases
Date: 2024-10-05 23:37:39
Message-ID: CAOLfK3Vnjoddno+Maj8bXoUVZWLAOgCwmotx02yyb92CMZ7zog@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, Oct 5, 2024 at 5:43 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> On 10/5/24 15:04, Matt Zagrabelny wrote:
>
> > psql (15.8 (Debian 15.8-0+deb12u1))
> >
> >
> > Where did you install it from or where are you running it?
> >
> >
> > Installed from Debian repos via apt via puppet.
> >
> > Still digging...
>
> To me it looks like something is doing:
>
> REVOKE CONNECT
> ON DATABASE <some_db>
> FROM PUBLIC;
>
>
I think we have a winner.

When puppet creates the database, it revokes connect:

https://github.com/puppetlabs/puppetlabs-postgresql/blob/main/manifests/server/database.pp#L55-L80

I'll have to ponder a solution. :(

Thanks for all the help (David, Adrian, and Tom)! I very much appreciate
you taking time to give me some guidance and pointers.

Cheers!

-m

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter J. Holzer 2024-10-06 12:18:34 Re: Repeatable Read Isolation Level "transaction start time"
Previous Message Adrian Klaver 2024-10-05 22:43:17 Re: grant connect to all databases