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 [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match