From: | wheelly(at)gmail(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #7578: Not able to drop user if S/he has permission on tablespace |
Date: | 2012-10-02 08:49:27 |
Message-ID: | E1TIyAR-0001qA-FF@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 7578
Logged by: Nikolay
Email address: wheelly(at)gmail(dot)com
PostgreSQL version: 9.1.4
Operating system: Linux version 3.2.0-3-amd64 (Debian 3.2.21-3)
Description:
Hello,
The bug is similar to existing bug "BUG #6116: Not able to drop user if S/he
has permission on tablespace".
http://archives.postgresql.org/pgsql-bugs/2011-07/msg00110.php
You wrote to mr. "tushar" <tushar(dot)qa(at)gmail(dot)com>:
------------------------------------------------------------------------
The "DROP OWNED BY" command only drops objects that are owned by a
user. It doesn't revoke privileges that user has granted: those
aren't considered dropable objects. So technically speaking all of
those commands are working just as expected.
------------------------------------------------------------------------
But documentation say reversal thing
(http://www.postgresql.org/docs/9.1/static/sql-drop-owned.html)
------------------------------------------------------------------------
DROP OWNED drops all the objects in the current database that are owned by
one of the specified roles.
Any privileges granted to the given roles on objects in the current database
will also be revoked.
------------------------------------------------------------------------
Where is a bug in PostgreSQL or in documentation?
Thank you,
Nikolay.
From | Date | Subject | |
---|---|---|---|
Next Message | Копыченко Павел | 2012-10-02 09:51:14 | Please could you provide more specific step by step instructions to build this driver psqlodbc-09.01.0200 under Windows. |
Previous Message | Heikki Linnakangas | 2012-10-02 08:26:24 | Re: BUG #7534: walreceiver takes long time to detect n/w breakdown |