Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

In Replication why we should not give write permission on subscribers Expand / Collapse
Author
Message
Posted Wednesday, July 9, 2014 1:57 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 11:11 PM
Points: 26, Visits: 111
Hi friends,

In our environment we have uni directional transactional replication setup.
if we give read write access to the user on subscription databases what will happen
and why we should not give rite waccess.

Thanks in advance

Regards
Sam


Regards,
SAM
***Share your knowledge.It’s a way to achieve immortality----Dalai Lama***
Post #1590634
Posted Wednesday, July 9, 2014 11:12 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 11:30 AM
Points: 11,299, Visits: 13,090
If you give write access to a subscriber changes made on the subscriber never make it to the publisher and it also will put replication out of sync. If you want to be able to write to both ends you need to look at merge or peer to peer replication.



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #1590871
Posted Wednesday, July 9, 2014 9:50 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 11:11 PM
Points: 26, Visits: 111
Hi Jack,

Thanks for prompt reply.
Can you briefly explain how replication will be out of sync. and will break the replication or will it through any error.

Thanks,
SAM


Regards,
SAM
***Share your knowledge.It’s a way to achieve immortality----Dalai Lama***
Post #1590990
Posted Friday, July 11, 2014 9:33 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 8:43 AM
Points: 820, Visits: 1,175
I will try to explain.

Lets assume you have given write permission on subscriber and somebody deletes a row which is in publisher and later somebody updates that row in publisher and now distributor will try to update that row on subscriber and since that row no longer exists replication will generate an error and will stop unless you have "Continue on data consistency error option" enabled.
Post #1591689
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse