I'm replicating a master database using transaction replication with no updates (i.e. the subscriber databse doesn't feed any data changes back to the master database). There are about 50 stored procedures that are also replicated. All user interaction for the subscriber database uses the SPs, so I don't need table-level accesses; but I can't seem to get the permissions for the SPs to replicate. The receiving database already has appropriate users and roles set up before the snapshot is applied at the beginning of the replication. Am I missing something? It seems kind of silly to have to manually tweak permissions every time the snapshot is updated.
TIA.
TIA.