4

I want to setup transactional replication on sql server. By following the instructions of the ms replication preparation tutorial and the ms replication configuration tutorial, everything works fine.

My question is: Why all these 4 users? Will there be any trouble if instead of 4 I only use one windows user/db login for every step?

Improve this question

1 Answer 1

Reset to default
5

If you use 1 user, you typically end up giving that user more access than it needs. By having the example use 4 different users, it helps demonstrate the good practice of using dedicated accounts for particular purposes. If one is compromised, there’s less impact on the overall system. If the example used just one user, everyone would assume it had to be that way.

Improve this answer
2
  • OK, I understand your comments about "good practice", which is of course what the tutorial should instruct. However, this also implies that there is no concern (security aside), of damaging the functionality. Right?
    – George Menoutis
    Commented Oct 8, 2018 at 10:24
  • Correct. Functionally you could use a single account.
    – Rob Farley
    Commented Oct 8, 2018 at 12:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.