title: Synonyms and Referential Integrity
body: <p>I have multiple database schemas in which some of the tables from one schema s1, need to reference tables from schema s2. I looked up synonym literature and haven't found much details about how I may use public synonyms for selecting, updating and referencing foreign keys, as well as how would the whole thing behave in matters of referential integrity. Should I use a <code>grant references, update, select, ...</code> on each table I need? it seems quite a poor way to accomplish the task</p>