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

From: "tushar" <tushar(dot)qa(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6116: Not able to drop user if S/he has permission on tablespace
Date: 2011-07-13 12:57:18
Message-ID: 201107131257.p6DCvIDA098948@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 6116
Logged by: tushar
Email address: tushar(dot)qa(at)gmail(dot)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=#

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2011-07-13 18:43:08 Re: [BUGS] extract(epoch from infinity) is not 0
Previous Message Craig Ringer 2011-07-12 23:58:30 Re: Fw: Re: [BUGS] BUG #6099: Does pgcluster support hibernate?