How to replicate database security (users, roles, ...) ?
in [Replication]
|
Prev: Microsoft Responds to the Evolution of Online Communities
Next: identity range allocation entry for Publisher not found
From: juvi on 5 May 2010 03:09 Hello, 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
From: Chris on 5 May 2010 22:44
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. Chris sqldatabasesolutions.com "juvi" wrote: > Hello, > > 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 |