ALL must be specified for REVOKE ALL ROLES

  Explanation:  REVOKE ALL ROLES must be specified to revoke all
  roles from an user or role.

  User Action:  Correct the syntax of the REVOKE statement