Our CEO Juice user login needs the following permissions in order for ID890 to update service call information in eAuto:
The CEO Juice SQL user already has READ rights to the entire eAuto DB and full rights to the CEO Juice database, then we additionally need to have INSERT/UPDATE rights to these tables in the eAuto DB:
SCWorkOrders
SCWorkOrderNotes
SCWorkOrderNoteDetails
SCCalls
SCCallsEx
SCCallNotes
SCCallNoteDetails
SCCallTechnicians
SCQReports
SCQReportMeterReadings
SCQReportLabors
SCQReportHolds
SCQReport
MTMeterReadingGroups
MTMeterReadings
**Note: this is a SQL user and permissions, not eAuto’s internal user/module rights.**
0 Comments