Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rc052-000PFI-SY for pgsql-general@arkaria.postgresql.org; Mon, 19 Feb 2024 09:36:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rc051-00EXUs-9c for pgsql-general@arkaria.postgresql.org; Mon, 19 Feb 2024 09:36:55 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rc050-00EXUj-S7 for pgsql-general@lists.postgresql.org; Mon, 19 Feb 2024 09:36:54 +0000 Received: from smtp5-g21.free.fr ([2a01:e0c:1:1599::14]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rc04x-007VBP-P7 for pgsql-general@lists.postgresql.org; Mon, 19 Feb 2024 09:36:53 +0000 Received: from zimbra-e1-02.priv.proxad.net (unknown [172.20.243.240]) by smtp5-g21.free.fr (Postfix) with ESMTP id D9A9F60142; Mon, 19 Feb 2024 10:36:47 +0100 (CET) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=free.fr; s=smtp-20201208; t=1708335408; bh=b8p066fKHZY34i2HNKr+t1Wzk1/F2v4VnFy9pIOY1KY=; h=Date:From:To:Cc:In-Reply-To:References:Subject:From; b=WMBGD+7mYZtUiyw5lYPsQmjy24AFrKD4gFE3Jwl8Cu0SL4t4Ue2abhwCR2H5EbCoP sx+FRZ5kdmpY1fy1RT5ZtDSr41ZI/+PnsJ1X08rRfW40ve7XOFuUH8N9qk4iLqPKEJ pGbgaKKKrRdmzbzz/Nrkql76LWvRY+rx929niZKcU+QIia3mqJYtMzCS7nDdXUQt6f RUQ468eNtYjchMljixhIoLs51bJCPKUASXioGJ8a0iV1X72YFVCSY2Z54H0x+cfOwB 6nEH7flsCBsFJ7OtFIFL76cLXQ5DDHMKnQ43i1OcsnsNx9XTQLEokK5n3TaoZCZ+u3 BktMo8O8oMxgA== Date: Mon, 19 Feb 2024 10:36:47 +0100 (CET) From: gparc@free.fr To: Dominique Devienne Cc: Lok P , pgsql-general Message-ID: <1079660266.467418040.1708335407832.JavaMail.zimbra@free.fr> In-Reply-To: References: Subject: Re: Users and object privileges maintenance MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="=_5f6e3808-e98f-4ce4-b451-d5d148476af6" X-Originating-IP: [145.242.20.133] X-Mailer: Zimbra 9.0.0_GA_1337 (ZimbraWebClient - FF115 (Linux)/9.0.0_GA_1337) Thread-Topic: Users and object privileges maintenance Thread-Index: HstYrtPQQ8Tb8YNpNERihnAp1iFfZg== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --=_5f6e3808-e98f-4ce4-b451-d5d148476af6 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit 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 [ https://www.postgresql.org/docs/15/ddl-schemas.html#DDL-SCHEMAS-PUBLIC | public schema ] Regards Gilles --=_5f6e3808-e98f-4ce4-b451-d5d148476af6 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
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 imp= licitly members of, had implicit access to newly created DBs.
It's still the same concerning default database CONNE=
CT privilege for PUBLIC.
You must confuse with the fact that v15+ remove= s PUBLIC creation permission on the public schema

Regards
Gilles

=


--=_5f6e3808-e98f-4ce4-b451-d5d148476af6--