| From: | "nobuyuki yoshida" <nob-yoshida(at)fissc(dot)co(dot)jp> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #5788: I can drop table , with other user's table |
| Date: | 2010-12-10 02:41:38 |
| Message-ID: | 201012100241.oBA2fcSN090343@wwwmaster.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 5788
Logged by: nobuyuki yoshida
Email address: nob-yoshida(at)fissc(dot)co(dot)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!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2010-12-10 07:55:32 | Re: variadic flag doesn't work with "any" type |
| Previous Message | Tom Lane | 2010-12-09 22:38:57 | Re: variadic flag doesn't work with "any" type |