How to replicate database security (users, roles, ...) ?
juvi
I am new to this replication stuff, but I have successfully set up my MERGE
REPLICATION which replicates TABLES, STORED PROCEDURES, USER DEFINED
FUNCTIONS.
Unfortunately I see that the whole security (users, roles, ...) are not
replicated in the subscriber database => is there a way to keep the security
also synchronized?
(As long as the security is not also available from the publisher DB to the
subscriber DB the option "Copy permissions" for the tables runs into an
error: "Cannot find the user "xyz" because it does not exist or you do not
have permissions.")
Thank you for your help in advance.
BR, juvi
Chris
The snapshot will send permissions to subscriber, visit article properties
of your pub.
Need to create sql login at subscriber w/ same name and give access to the
subscriber db. Then initialize, the snapshot agent will deliver permissions.
Once merge is running, changes to perms will not replicate so you have to
apply at both pub & sub.