Available only at the host site and only when a satellite slot is not in use, this command drops and re-creates all existing proxy users for the satellite slot.
We recommend re-creating proxy users when collaboration has failed for a same-instance satellite or when a privilege problem seems to exist, causing collaboration to fail for either separate or same-instance satellite slots.
When working with proxy users, keep the following scenarios in mind:
Same database instance
Sites are in different database instances, but the plant structures are in the same database instance. In this situation, the user names at the host and satellite sites cannot be the same. You were asked to create the proxy user names during the satellite slot creation.
Different database instance
If user names at the host do not match the user names at the satellite, a proxy user must be created at the host site to provide a way of granting the remote user the ability to talk to the tables in the host database instance. If the user names at the host do match the user names at the satellite, proxy user names are not needed.