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

From Tom Lane
Subject Re: BUG #14131: BUG, schema owner can drop otheruser's object in it's schema
Date
Msg-id 2140.1462888753@sss.pgh.pa.us
Whole thread Raw
In response to 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
digoal@126.com writes:
> schema r1's owenr is r1.
> i create two table in schema r1, these table's owner is r2 and postgres. but
> schema r1's owner r1 can drop r2 and postgres's table in schema r1.

This is  the intended and documented behavior.  It's no different than
if a database owner chooses to drop a database.

            regards, tom lane

pgsql-bugs by date:

Previous
From: digoal@126.com
Date:
Subject: BUG #14131: BUG, schema owner can drop otheruser's object in it's schema
Next
From: "David G. Johnston"
Date:
Subject: Re: BUG #14131: BUG, schema owner can drop otheruser's object in it's schema