I got a broader view of the whole picture and obviously my proposal
that the superuser automatically revokes the privileges granted by all
others does not make sense. So let me state the solutions I propose to
the problem I'm facing:
(1) In the documentation for REVOKE, after the paragraph
On 05/30/2007 08:44:19 PM, Pedro Gimeno Fortea wrote:
Note that this is not similar to the GRANT case. I'd say it's similar
to wanting to delete a table created by another user: if you're not
the owner, you can't, unless you're a superuser. The similarity
becomes obvious when replacing "del
On 05/30/2007 07:55:58 PM, Tom Lane wrote:
Pedro Gimeno Fortea <[EMAIL PROTECTED]> writes:
> Still, is silently ignoring the command the proper action to take
> when the REVOKE is executed by the superuser and not by the
> grantor?
You want a warning when REVOKE didn't do anything because ther
Pedro Gimeno Fortea <[EMAIL PROTECTED]> writes:
> On 05/30/2007 06:57:39 PM, Tom Lane wrote:
>> 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?
You wan
On 05/30/2007 06:57:39 PM, Tom Lane wrote:
Pedro Gimeno Fortea <[EMAIL PROTECTED]> 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 def
On 05/29/2007 03:35:00 PM, Tom Lane wrote:
"Pedro Gimeno" <[EMAIL PROTECTED]> writes:
> When a USAGE grant on a SCHEMA is given by an user (non-superuser
> in my case), the superuser can't revoke it; instead the REVOKE
> statement is silently ignored.
This is not a bug. If you want to revoke t
Pedro Gimeno Fortea <[EMAIL PROTECTED]> 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.
"Pedro Gimeno" <[EMAIL PROTECTED]> writes:
> When a USAGE grant on a SCHEMA is given by an user (non-superuser in my
> case), the superuser can't revoke it; instead the REVOKE statement is
> silently ignored.
This is not a bug. If you want to revoke the privilege, revoke the
GRANT OPTION you orig
The following bug has been logged online:
Bug reference: 3319
Logged by: Pedro Gimeno
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.4
Operating system: Linux
Description:Superuser can't revoke grants on a schema given by
aother user
Details:
When a USAGE
