So, in my case that they are editing the features through a service, do I still need to do the first two steps (described below) or just the other steps (1-4)?
1. Add their windows account to SQL Server
2. Grant their account UPDATE, INSERT, SELECT, DELETE privileges using the Change Privileges tool
Thank you for the detailed explanation!