Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1peETj-0004Jx-0d for pgsql-general@arkaria.postgresql.org; Mon, 20 Mar 2023 12:19:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1peETh-0003Sl-OL for pgsql-general@arkaria.postgresql.org; Mon, 20 Mar 2023 12:19:05 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1peETh-0003Sc-Dq for pgsql-general@lists.postgresql.org; Mon, 20 Mar 2023 12:19:05 +0000 Received: from mout-u-107.mailbox.org ([2001:67c:2050:101:465::107]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1peETf-0001Ij-0H for pgsql-general@postgresql.org; Mon, 20 Mar 2023 12:19:04 +0000 Received: from smtp2.mailbox.org (smtp2.mailbox.org [IPv6:2001:67c:2050:b231:465::2]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange ECDHE (P-384) server-signature RSA-PSS (4096 bits) server-digest SHA256) (No client certificate requested) by mout-u-107.mailbox.org (Postfix) with ESMTPS id 4PgDL92Qxlz9sZl; Mon, 20 Mar 2023 13:18:57 +0100 (CET) Date: Mon, 20 Mar 2023 13:18:56 +0100 (CET) From: Erik Wienhold To: Dominique Devienne , pgsql-general@postgresql.org Message-ID: <1626848226.954543.1679314736718@office.mailbox.org> In-Reply-To: References: Subject: Re: NULL pg_database.datacl MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Priority: 3 Importance: Normal X-Rspamd-Queue-Id: 4PgDL92Qxlz9sZl List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On 20/03/2023 11:52 CET Dominique Devienne wrote: > > Hi. I'm surprised, I thought ACLs would never be empty for a database. > Does that mean nobody can connect to this database? > I guess SUPERUSER and/or its datDBA can? > What does a NULL AclItem[] mean exactly? It means that the object has default privileges (before any GRANT or REVOKE is executed). For databases this means full privileges for the database owner and the CONNECT and TEMPORARY privileges for PUBLIC. So any user can connect if allowed by pg_hba.conf. https://www.postgresql.org/docs/current/ddl-priv.html -- Erik