Re: SQL command : ALTER DATABASE OWNER TO

From: gparc(at)free(dot)fr
To: pgsql-docs <pgsql-docs(at)lists(dot)postgresql(dot)org>
Subject: Re: SQL command : ALTER DATABASE OWNER TO
Date: 2024-01-24 10:08:21
Message-ID: 1712096587.208766558.1706090901073.JavaMail.zimbra@free.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Hello,

as one of my colleagues fell into the same trap
I repeat my request for correction of the documentation on this subject.

Many thanks in advance

Regards
Gilles

----- Mail original -----
De: "gparc" <gparc(at)free(dot)fr>
À: "pgsql-docs" <pgsql-docs(at)lists(dot)postgresql(dot)org>
Envoyé: Mardi 8 Mars 2022 10:50:38
Objet: SQL command : ALTER DATABASE OWNER TO

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.

Regards
Gilles

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Laurenz Albe 2024-01-24 14:23:21 Re: SQL command : ALTER DATABASE OWNER TO
Previous Message Daniel Gustafsson 2024-01-24 09:19:29 Re: Missing information on '-X' in section 26.3.6.1.