Example: Using the Site User Map Tab
You have three sites that are sharing data through non-transactional replication: OHIO, ARIZ, and MICH. While logged into the OHIO site, set up site user maps in the Sites or Sites/Entities form for ARIZ and MICH, with the From Site set to OHIO and the User set to repl_user. Tthis user is defined in all three sites. In ARIZ, set up site user maps connecting to OHIO and to MICH. In MICH, set up site user maps connecting to ARIZ and to OHIO.
In ARIZ, the Site User Maps setup looks like this for the three site records in the Sites or Sites/Entities form:
Site Record | From Site | User Name |
---|---|---|
ARIZ | (blank) | (blank) |
MICH | ARIZ | repl_user |
OHIO | ARIZ | repl_user |
In OHIO, the Site User Maps setup looks like this for the three site records in the Sites or Sites/Entities form:
Site Record | From Site | User Name |
---|---|---|
ARIZ | OHIO | repl_user |
MICH | OHIO | repl_user |
OHIO | (blank) | (blank) |
In MICH, the Site User Maps setup looks like this for the three site records in the Sites or Sites/Entities form:
Site Record | From Site | User Name |
---|---|---|
ARIZ | MICH | repl_user |
MICH | (blank) | (blank) |
OHIO | MICH | repl_user |