I need to grant access to a few users in the replicated copy of a database without losing their permissions every time replication runs.
Is there a way to support replication without losing permissions?
Are you snapshotting? You shouldn't lose permissions otherwise, so I guess you must be.
You can add a post replication file to run the permissions into the database once the snapshot has finished, its under the properties for the snapshot.
No one has followed this question yet.