Postgres Pro
Downloads
Home   >   mailing lists

Re: Users and object privileges maintenance - Mailing list pgsql-general

From gparc@free.fr
Subject Re: Users and object privileges maintenance
Date
Msg-id 1079660266.467418040.1708335407832.JavaMail.zimbra@free.fr
Whole thread Raw
In response to Re: Users and object privileges maintenance  (Dominique Devienne <ddevienne@gmail.com>)
List pgsql-general
Tree view
On 18.02.2024 15:19, Dominique Devienne wrote:
         ...
         ...
But you of course can connect only to DBs you have explicit access to. Just beware that before 15, the built-in PUBLIC
role, which all ROLEs are implicitly members of, had implicit access to newly created DBs.
It's still the same concerning default database CONNECT privilege for PUBLIC.
You must confuse with the fact that v15+ removes PUBLIC creation permission on the public schema

Regards
Gilles




pgsql-general by date:

Previous
From: Darryl Green
Date:
Subject: Re: Partitioning, Identity and Uniqueness (given pg 16 changes)
Next
From: "David G. Johnston"
Date:
Subject: Re: Partitioning, Identity and Uniqueness (given pg 16 changes)