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