Re: SQL command : ALTER DATABASE OWNER TO

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: SQL command : ALTER DATABASE OWNER TO
Дата
Msg-id YidqjxKfp1Ao/txA@momjian.us
обсуждение исходный текст
Ответ на SQL command : ALTER DATABASE OWNER TO  (gparc@free.fr)
Ответы Re: SQL command : ALTER DATABASE OWNER TO  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-docs
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 по дате отправления:

Предыдущее
От: gparc@free.fr
Дата:
Сообщение: SQL command : ALTER DATABASE OWNER TO
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: SQL command : ALTER DATABASE OWNER TO