Re: grant connect to all databases
| От | Matt Zagrabelny |
|---|---|
| Тема | Re: grant connect to all databases |
| Дата | |
| Msg-id | CAOLfK3Vnjoddno+Maj8bXoUVZWLAOgCwmotx02yyb92CMZ7zog@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: grant connect to all databases (Adrian Klaver <adrian.klaver@aklaver.com>) |
| Список | pgsql-general |
On Sat, Oct 5, 2024 at 5:43 PM Adrian Klaver <adrian.klaver@aklaver.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:
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
В списке pgsql-general по дате отправления: