User Permissions changes when replication takes place

• Senthil-422169

  Newbie

  Points: 7

  More actions

  March 24, 2007 at 5:41 am

  #95044

  hi all,

  i have replicated from Server (A) to Server (b).for this i have made a schedule for every one day.data's are replicated perfectly. but in the server (B) certain replicated tables loose its user's permissions.i have used snap-shot replication.

  i want to know,what's the reason for the change of user Permissions.

    

   

• happycat59

  One Orange Chip

  Points: 29451

  More actions

  March 25, 2007 at 10:01 pm

  #696802

  Replication does not replicate permission changes - and it never sets them in the first place. You will need to implement these yourself.

  Replication creates tables etc when a snapshot is delivered to the subscriber BUT it does not include any permissions.