Re: [BUGS] BUG #14540: REASSIGN OWNED cannot reassign from a USER toa ROLE

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: [BUGS] BUG #14540: REASSIGN OWNED cannot reassign from a USER toa ROLE
Дата
Msg-id 20170210164054.vcxz3c3pp52kxv2g@alvherre.pgsql
обсуждение исходный текст
Ответ на [BUGS] BUG #14540: REASSIGN OWNED cannot reassign from a USER to a ROLE  (opldupuy@gmail.com)
Список pgsql-bugs
opldupuy@gmail.com wrote:

> I highly suggest extending REASSIGN OWNED to:
> - reassign USER resources to ROLE first (current user has to be in the
> target role as now)
> - reassign USER resources to USER next

In Postgres, "users" are just roles.  There is no distinction.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Cliff Inbau
Дата:
Сообщение: Re: [BUGS] BUG #14536: Centos 7 gdal-libs Dependency Problem
Следующее
От: Devrim Gündüz
Дата:
Сообщение: Re: [BUGS] BUG #14536: Centos 7 gdal-libs Dependency Problem