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