Previous Topic: CAD2302W Grant failed, resource name specified in grant statement does not existNext Topic: CAD2304E No grant or revoke statement in SYSIN file

ACFD2 Messages › CAD2 Synchronization Utility Messages › CAD2303W Revoke failed, revokee owns the resource, revokee does not have privilege or revoker did not grant privilege

CAD2303W Revoke failed, revokee owns the resource, revokee does not have privilege or revoker did not grant privilege

Reason

The revoke statement preceding this message failed for one of three reasons:

  1. The revokee is the owner of the resource. DB2 grants the creator of a resource all privileges for that resource, these privileges cannot be revoked. This is probably the reason the revoke failed.
  2. The revokee no longer holds the privilege. This might occur if any catalog maintenance was performed between the time CADB2SY2 was run and the time the revoke was executed.
  3. The revoker did not grant the privilege. This occurs only if you created your own input to CADB2SY3 and did not include the “BY ALL” clause on the revoke, or if you modified the output from CADB2SY2 and removed the “BY ALL” clause.

Action

This message is informational only. No action is required.