When deploying our product to different customers, the question often comes up with what are the SQL User Minimum Permissions needed to run the software. We aren’t adding anything that would require more than db_datareader and db_datawriter for the minimum permissions. I’ve discovered that the numberIdService may create additional schema if needed which would obviously exceed these permissions. If we have the schema already created then this doesn’t seem to be an issue.
What does Cuba recommend for the minimum user permissions for the SQL Connection for production? Studio will obviously require more permissions as we are manipulating schema. Are there other areas of concern like numberIdService that we should be aware of?