patternsqlMinor
Can I use only 1 user for SQL Server replication?
Viewed 0 times
cansqluserreplicationforserveruseonly
Problem
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?
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?
Solution
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.
Context
StackExchange Database Administrators Q#219518, answer score: 5
Revisions (0)
No revisions yet.