Fabien COELHO <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
