Tom Lane writes:
> So an owner can never revoke his own grant options? That seems
> reasonable offhand, and compatible with our previous notion that
> the owner's ability to GRANT was inherent and nonrevocable.
>
> But I wonder how this squares with the SQL spec...
The root of this problem is that revoking privileges from the owner
doesn't square with the SQL spec in the first place. Allowing having a
grant option without the privilege is not a state that's supported by the
SQL standard, but it just continues the practice we've always had. This
patch just takes care that the recursive revoke action is not invoked in
this case.
--
Peter Eisentraut peter_e@gmx.net