Thanks! I realized that this can't be done without the two roles across schemas other than the way you mentioned.