Re: BUG #1150: grant options not properly checked

Fabien COELHO <coelho@cri.ensmp.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