Date: Tue, 8 Mar 2022 09:39:11 -0500
From: Bruce Momjian <bruce@momjian.us>
To: gparc@free.fr
Cc: pgsql-docs@lists.postgresql.org
Subject: Re: SQL command : ALTER DATABASE OWNER TO
Message-ID: <YidqjxKfp1Ao/txA@momjian.us>
References: 
 <1216810578.281812820.1646732222284.JavaMail.root@zimbra15-e2.priv.proxad.net>
 <2023185982.281851219.1646733038464.JavaMail.root@zimbra15-e2.priv.proxad.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <2023185982.281851219.1646733038464.JavaMail.root@zimbra15-e2.priv.proxad.net>
Archived-At: 
 <https://www.postgresql.org/message-id/YidqjxKfp1Ao/txA%40momjian.us>
Precedence: bulk

On Tue, Mar  8, 2022 at 10:50:38AM +0100, gparc@free.fr wrote:
> 
> Hello,
> 
> for this "ALTER DATABASE" form, it should be mentioned that after execution of the command,
> the old database owner loses all his privileges on it (even connection) although it might
> still owns schemas or objects (tables, index,...) inside it.
> 
> Thanks in advance to add this important precision.

Uh, the original owner is not the owner anymore, so why would they
assume they can reconnect, unless there is some other permission
specified for them.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  If only the physical world exists, free will is an illusion.