Re: BUG #14540: REASSIGN OWNED cannot reassign from a USER to a ROLE

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: opldupuy(at)gmail(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14540: REASSIGN OWNED cannot reassign from a USER to a ROLE
Date: 2017-02-10 16:40:54
Message-ID: 20170210164054.vcxz3c3pp52kxv2g@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

opldupuy(at)gmail(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Devrim Gündüz 2017-02-10 18:53:13 Re: BUG #14536: Centos 7 gdal-libs Dependency Problem
Previous Message Cliff Inbau 2017-02-10 16:12:49 Re: BUG #14536: Centos 7 gdal-libs Dependency Problem