Search Postgresql Archives

Re: grant connect to all databases

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On Sat, Oct 5, 2024 at 5:43 PM Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux