| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | gparc(at)free(dot)fr |
| Cc: | pgsql-docs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: SQL command : ALTER DATABASE OWNER TO |
| Date: | 2022-03-08 14:39:11 |
| Message-ID: | YidqjxKfp1Ao/txA@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
On Tue, Mar 8, 2022 at 10:50:38AM +0100, gparc(at)free(dot)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(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com
If only the physical world exists, free will is an illusion.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2022-03-08 15:06:53 | Re: SQL command : ALTER DATABASE OWNER TO |
| Previous Message | gparc | 2022-03-08 09:50:38 | SQL command : ALTER DATABASE OWNER TO |