Re: BUG #14131: BUG, schema owner can drop otheruser's object in it's schema - Mailing list pgsql-bugs

From Euler Taveira
Subject Re: BUG #14131: BUG, schema owner can drop otheruser's object in it's schema
Date
Msg-id 573250F4.6030609@timbira.com.br
Whole thread Raw
In response to Re: BUG #14131: BUG, schema owner can drop otheruser's object in it's schema  (德哥 <digoal@126.com>)
Responses Re: BUG #14131: BUG, schema owner can drop otheruser's object in it's schema
List pgsql-bugs
On 10-05-2016 12:55, µÂ¸ç wrote:
> I think we can improve friendly.
> like this :
> drop object direct , if user it's not superuser & owner, then error.
> and when drop schema or database.
>
I don't buy that it is an improvement. First, you will break
applications that rely on that behavior since 7.3 (2002). Second, we
have workaround to avoid such DROP occurs -- set a reliable schema owner.


--
   Euler Taveira                   Timbira - http://www.timbira.com.br/
   PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

pgsql-bugs by date:

Previous
From: fiercetuba@protonmail.com
Date:
Subject: BUG #14132: ON CONFLICT not inferring unique index with bigints
Next
From: 德哥
Date:
Subject: Re: BUG #14131: BUG, schema owner can drop otheruser's object in it's schema