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