Suppose you have an sde schema database in SQL Server. The sde user owns the repository but no data.
Suppose you create a data loader account (SQL account), with create table and create procedure permissions, and load some data.
When you connect to your SDE database in ArcCatalog, in order to Create a Replica, the "database user must have write access to the data". Given that requirement, neither the sde user nor the GIS data loader would have that ability as I've outlined above, correct?
Can you elaborate on creating replicas with an SDE schema? I'm wondering if there are any special considerations for which logins to use when creating replicas. For example, do you have to use the same level of permissions for both parent and child?
I ask because I'm having an issue with a two-way replica. The child's edits come back to the parent every time without fail, but edits made on the parent do not transfer to the child. I looked at the A and D tables for the feature classes affected, and the records seem to get orphaned in those tables instead of transferring. I'm to the point now where I'm rebuilding the replica once a week, which suggests to me that I'm making a mistake in the setup.