Changing Table Owner

Replication Server treats tables with different owners as different tables. You must make the relevant change to the table replication definitions if you use alter...modify owner to change the owner for an Adaptive Server replicated table.

1. Create new table replication definitions with the new owner in the primary Replication Server.
   Note: There may be multiple replication definitions for a primary table. You have to create new replicaton definitions with the new owner to replace existing replication definitions.
2. If there are subscriptions against the replication definitions for the current owner, create subscriptions against the new replication definitions in the replicate Replication Servers.
3. If there are customized function strings against the replication definitions for the current owner, create customized function strings against the new replication definitions in the primary Replication Servers.
4. Change the table owner in the primary Adaptive Server.
5. (Optional) Drop current subscriptions and replication definitions.
   1. Wait until data for the table with the current owner are all processed.
   2. Drop the subscriptions for the replication definitions created against the current table owner in the replicate Replication Servers.
   3. Drop the replication definitions for the current owners in the primary Replication Server.