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

Поиск
Список
Период
Сортировка
От nobuyuki yoshida
Тема BUG #5788: I can drop table , with other user's table
Дата
Msg-id 201012100241.oBA2fcSN090343@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #5788: I can drop table , with other user's table  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
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!

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: variadic flag doesn't work with "any" type
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #5788: I can drop table , with other user's table