The user accessing other schema to compare would need the SELECT ANY TABLE privilege and the SELECTCATALOGROLE role.