Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group