Re: BUG #3319: Superuser can't revoke grants on a schema given by aother user

From: Pedro Gimeno Fortea <pgsql(at)personal(dot)formauri(dot)es>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3319: Superuser can't revoke grants on a schema given by aother user
Date: 2007-05-30 17:21:00
Message-ID: 1180545660l.8394l.1l@dirtecnica.formauri.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 05/30/2007 06:57:39 PM, Tom Lane wrote:
> Pedro Gimeno Fortea <pgsql(at)personal(dot)formauri(dot)es> writes:
> > On 05/29/2007 03:35:00 PM, Tom Lane wrote:
> >> This is not a bug. If you want to revoke the privilege, revoke
> >> the GRANT OPTION you originally gave.
>
> > Why should I?
>
> Because that's how the SQL spec defines that it works.

Still, is silently ignoring the command the proper action to take when
the REVOKE is executed by the superuser and not by the grantor?

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2007-05-30 17:55:58 Re: BUG #3319: Superuser can't revoke grants on a schema given by aother user
Previous Message Jeff Davis 2007-05-30 17:00:32 Re: BUG #3320: Error when using INSERT...RETURNING as a subquery