Re: BUG #14131: BUG, schema owner can drop otheruser's object in it's schema

From: Euler Taveira <euler(at)timbira(dot)com(dot)br>
To: 德哥 <digoal(at)126(dot)com>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #14131: BUG, schema owner can drop otheruser's object in it's schema
Date: 2016-05-10 21:21:56
Message-ID: 573250F4.6030609@timbira.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message 德哥 2016-05-11 00:46:41 Re: BUG #14131: BUG, schema owner can drop otheruser's object in it's schema
Previous Message fiercetuba 2016-05-10 19:03:50 BUG #14132: ON CONFLICT not inferring unique index with bigints