Postgres Pro
Downloads
Home   >   mailing lists

Re: SQL command : ALTER DATABASE OWNER TO - Mailing list pgsql-docs

From Bruce Momjian
Subject Re: SQL command : ALTER DATABASE OWNER TO
Date
Msg-id YidqjxKfp1Ao/txA@momjian.us
Whole thread Raw
In response to SQL command : ALTER DATABASE OWNER TO  (gparc@free.fr)
Responses Re: SQL command : ALTER DATABASE OWNER TO  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-docs
Tree view 
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.

pgsql-docs by date:

Previous
From: gparc@free.fr
Date:
Subject: SQL command : ALTER DATABASE OWNER TO
Next
From: "David G. Johnston"
Date:
Subject: Re: SQL command : ALTER DATABASE OWNER TO