BUG #5788: I can drop table , with other user's table

Started by nobuyuki yoshidaover 15 years ago2 messagesbugs
Jump to latest
#1nobuyuki yoshida
nob-yoshida@fissc.co.jp

The following bug has been logged online:

Bug reference: 5788
Logged by: nobuyuki yoshida
Email address: nob-yoshida@fissc.co.jp
PostgreSQL version: 8.4.5
Operating system: centos 5.5
Description: I can drop table , with other user's table
Details:

Hi. I found a bug:I can drop a table with not owner user.
Document says "Only its owner can drop a table.", but a fuct is not so.

Here is steps to reproduce:
1. command with postgres on psql
create schema scm_test;
create user scm_test;
alter schema scm_test owner to scm_test;
create table scm_test.test (id char(10));

2. command with scm_test on psql
drop table test;

Then, success drop user postgres's table with user scm_test!

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: nobuyuki yoshida (#1)
Re: BUG #5788: I can drop table , with other user's table

"nobuyuki yoshida" <nob-yoshida@fissc.co.jp> writes:

Hi. I found a bug:I can drop a table with not owner user.
Document says "Only its owner can drop a table.", but a fuct is not so.

The documentation also says that the owner of a schema can drop anything
in that schema.

regards, tom lane