The following bug has been logged online: Bug reference: 6116 Logged by: tushar Email address: tushar...@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=# -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs