Re: BUG #1150: grant options not properly checked

Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> writes:
> While browsing the Access Rules of <revoke statement>... it is unclear.

I generally find SQL92 easier to read than SQL99. In SQL92,
section 11.37 <revoke statement> says

8) For every combination of <grantee> and <action> on O specified
in <privileges>, if there is no corresponding privilege de-
scriptor in the set of identified privilege descriptors, then a
completion condition is raised: warning-privilege not revoked.

9) If ALL PRIVILEGES was specified, then for each <grantee>, if
no privilege descriptors were identified, then a completion
condition is raised: warning-privilege not revoked.

which seems parallel to the GRANT case: warning, but no error.

regards, tom lane