BUG #6116: Not able to drop user if S/he has permission on tablespace

Поиск
Список
Период
Сортировка
От tushar
Тема BUG #6116: Not able to drop user if S/he has permission on tablespace
Дата
Msg-id 201107131257.p6DCvIDA098948@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #6116: Not able to drop user if S/he has permission on tablespace  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      6116
Logged by:          tushar
Email address:      tushar.qa@gmail.com
PostgreSQL version: 9.0
Operating system:   Fedora 14
Description:        Not able to drop user if S/he has permission on
tablespace
Details:

Steps to reproduce
================

\\create a directory

postgres=# \! mkdir /tmp/g100

\\create a tablespace
postgres=#  CREATE TABLESPACE f location '/tmp/g100';
CREATE TABLESPACE

\\create a User
postgres=# CREATE user abc;
CREATE ROLE

\\grant all on tablespace to user

postgres=# GRANT all on TABLESPACE f to abc;
GRANT

\\drop permission from user

postgres=# drop owned by abc;
DROP OWNED

\\ Try to drop User
postgres=# drop user abc ;
ERROR:  role "abc" cannot be dropped because some objects depend on it
DETAIL:  privileges for tablespace f
postgres=#

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Window function bug
Следующее
От: "Aleksey Tsalolikhin"
Дата:
Сообщение: BUG #6117: psql -c does not work as expected. a documentation bug? a program bug?