Minimum SQL Security Requirements for Catalina API

Minimum:
db_datawriter
db_datareader
db_ddladmin

If you are going to use our userMaintenance web service, to manage SL user logins, it will also need:
db_securityadmin
db_accessadmin

Also note that by default, we normally install our scripts under the dbo schema. So, you also have to give the user, we are connecting as, execute on that schema.

eg. grant  execute on schema :: [dbo] to usernamehere
PH and Temperature Hydroponic Monitor using MQTT
Catalina’s SL User Group Deep Dive for DSLUG 2019

Leave a Reply

Your email address will not be published / Required fields are marked *