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=#