API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 18th, 2019
160
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 84.28 KB | None | 0 0
raw download clone embed print report
  1. PREVENT THIS FROM HAPPENING!
  2.  
  3. UPDATE `opendental`.`procedurelog` SET `DateTStamp`='2022-04-18 13:44:13' WHERE `ProcNum`='1';
  4. UPDATE `opendental`.`procedurelog` SET `HideGraphics`='1' WHERE `ProcNum`='1';
  5.  
  6.  
  7. GETTING TABLE AND COLUMN NAME NOTES!
  8.  
  9. SELECT CONCAT("GRANT UPDATE ON opendental.", table_name, " TO 'root'@'%';")
  10.  
  11. FROM information_schema.TABLES
  12.  
  13. WHERE table_schema = "opendental" AND table_name <> "procedurelog";
  14.  
  15. SELECT COLUMN_NAME FROM information_schema.columns
  16.  
  17. WHERE table_schema = 'opendental' AND table_name = 'procedurelog';
  18.  
  19.  
  20. REVOKE NOTES!
  21.  
  22. REVOKE ALL ON *.* FROM 'user'@'::1';
  23. REVOKE ALL ON opendental.* FROM 'user'@'::1';
  24. REVOKE ALL ON *.* FROM 'user'@'localhost';
  25. REVOKE ALL ON opendental.* FROM 'user'@'localhost';
  26. REVOKE ALL ON *.* FROM 'user'@'127.0.0.1';
  27. REVOKE ALL ON opendental.* FROM 'user'@'127.0.0.1';
  28. REVOKE ALL ON *.* FROM 'user'@'%';
  29. REVOKE ALL ON opendental.* FROM 'user'@'%';
  30.  
  31. GRANT NOTES!
  32.  
  33. GRANT ALL ON opendental.account TO 'user'@'%';
  34. GRANT ALL ON opendental.accountingautopay TO 'user'@'%';
  35. GRANT ALL ON opendental.adjustment TO 'user'@'%';
  36. GRANT ALL ON opendental.alertcategory TO 'user'@'%';
  37. GRANT ALL ON opendental.alertcategorylink TO 'user'@'%';
  38. GRANT ALL ON opendental.alertitem TO 'user'@'%';
  39. GRANT ALL ON opendental.alertread TO 'user'@'%';
  40. GRANT ALL ON opendental.alertsub TO 'user'@'%';
  41. GRANT ALL ON opendental.allergy TO 'user'@'%';
  42. GRANT ALL ON opendental.allergydef TO 'user'@'%';
  43. GRANT ALL ON opendental.anestheticdata TO 'user'@'%';
  44. GRANT ALL ON opendental.anestheticrecord TO 'user'@'%';
  45. GRANT ALL ON opendental.anesthmedsgiven TO 'user'@'%';
  46. GRANT ALL ON opendental.anesthmedsintake TO 'user'@'%';
  47. GRANT ALL ON opendental.anesthmedsinventory TO 'user'@'%';
  48. GRANT ALL ON opendental.anesthmedsinventoryadj TO 'user'@'%';
  49. GRANT ALL ON opendental.anesthmedsuppliers TO 'user'@'%';
  50. GRANT ALL ON opendental.anesthscore TO 'user'@'%';
  51. GRANT ALL ON opendental.anesthvsdata TO 'user'@'%';
  52. GRANT ALL ON opendental.appointment TO 'user'@'%';
  53. GRANT ALL ON opendental.appointmentrule TO 'user'@'%';
  54. GRANT ALL ON opendental.appointmenttype TO 'user'@'%';
  55. GRANT ALL ON opendental.apptfield TO 'user'@'%';
  56. GRANT ALL ON opendental.apptfielddef TO 'user'@'%';
  57. GRANT ALL ON opendental.apptreminderrule TO 'user'@'%';
  58. GRANT ALL ON opendental.apptremindersent TO 'user'@'%';
  59. GRANT ALL ON opendental.apptview TO 'user'@'%';
  60. GRANT ALL ON opendental.apptviewitem TO 'user'@'%';
  61. GRANT ALL ON opendental.asapcomm TO 'user'@'%';
  62. GRANT ALL ON opendental.autocode TO 'user'@'%';
  63. GRANT ALL ON opendental.autocodecond TO 'user'@'%';
  64. GRANT ALL ON opendental.autocodeitem TO 'user'@'%';
  65. GRANT ALL ON opendental.automation TO 'user'@'%';
  66. GRANT ALL ON opendental.automationcondition TO 'user'@'%';
  67. GRANT ALL ON opendental.autonote TO 'user'@'%';
  68. GRANT ALL ON opendental.autonotecontrol TO 'user'@'%';
  69. GRANT ALL ON opendental.benefit TO 'user'@'%';
  70. GRANT ALL ON opendental.canadiannetwork TO 'user'@'%';
  71. GRANT ALL ON opendental.carrier TO 'user'@'%';
  72. GRANT ALL ON opendental.cdcrec TO 'user'@'%';
  73. GRANT ALL ON opendental.cdspermission TO 'user'@'%';
  74. GRANT ALL ON opendental.centralconnection TO 'user'@'%';
  75. GRANT ALL ON opendental.chartview TO 'user'@'%';
  76. GRANT ALL ON opendental.claim TO 'user'@'%';
  77. GRANT ALL ON opendental.claimattach TO 'user'@'%';
  78. GRANT ALL ON opendental.claimcondcodelog TO 'user'@'%';
  79. GRANT ALL ON opendental.claimform TO 'user'@'%';
  80. GRANT ALL ON opendental.claimformitem TO 'user'@'%';
  81. GRANT ALL ON opendental.claimpayment TO 'user'@'%';
  82. GRANT ALL ON opendental.claimproc TO 'user'@'%';
  83. GRANT ALL ON opendental.claimsnapshot TO 'user'@'%';
  84. GRANT ALL ON opendental.claimtracking TO 'user'@'%';
  85. GRANT ALL ON opendental.claimvalcodelog TO 'user'@'%';
  86. GRANT ALL ON opendental.clearinghouse TO 'user'@'%';
  87. GRANT ALL ON opendental.clinic TO 'user'@'%';
  88. GRANT ALL ON opendental.clinicerx TO 'user'@'%';
  89. GRANT ALL ON opendental.clinicpref TO 'user'@'%';
  90. GRANT ALL ON opendental.clockevent TO 'user'@'%';
  91. GRANT ALL ON opendental.codesystem TO 'user'@'%';
  92. GRANT ALL ON opendental.commlog TO 'user'@'%';
  93. GRANT ALL ON opendental.commoptout TO 'user'@'%';
  94. GRANT ALL ON opendental.computer TO 'user'@'%';
  95. GRANT ALL ON opendental.computerpref TO 'user'@'%';
  96. GRANT ALL ON opendental.confirmationrequest TO 'user'@'%';
  97. GRANT ALL ON opendental.connectiongroup TO 'user'@'%';
  98. GRANT ALL ON opendental.conngroupattach TO 'user'@'%';
  99. GRANT ALL ON opendental.contact TO 'user'@'%';
  100. GRANT ALL ON opendental.county TO 'user'@'%';
  101. GRANT ALL ON opendental.covcat TO 'user'@'%';
  102. GRANT ALL ON opendental.covspan TO 'user'@'%';
  103. GRANT ALL ON opendental.cpt TO 'user'@'%';
  104. GRANT ALL ON opendental.creditcard TO 'user'@'%';
  105. GRANT ALL ON opendental.custrefentry TO 'user'@'%';
  106. GRANT ALL ON opendental.custreference TO 'user'@'%';
  107. GRANT ALL ON opendental.cvx TO 'user'@'%';
  108. GRANT ALL ON opendental.dashboardar TO 'user'@'%';
  109. GRANT ALL ON opendental.dashboardcell TO 'user'@'%';
  110. GRANT ALL ON opendental.dashboardlayout TO 'user'@'%';
  111. GRANT ALL ON opendental.databasemaintenance TO 'user'@'%';
  112. GRANT ALL ON opendental.dbmlog TO 'user'@'%';
  113. GRANT ALL ON opendental.definition TO 'user'@'%';
  114. GRANT ALL ON opendental.deflink TO 'user'@'%';
  115. GRANT ALL ON opendental.deletedobject TO 'user'@'%';
  116. GRANT ALL ON opendental.deposit TO 'user'@'%';
  117. GRANT ALL ON opendental.dictcustom TO 'user'@'%';
  118. GRANT ALL ON opendental.discountplan TO 'user'@'%';
  119. GRANT ALL ON opendental.disease TO 'user'@'%';
  120. GRANT ALL ON opendental.diseasedef TO 'user'@'%';
  121. GRANT ALL ON opendental.displayfield TO 'user'@'%';
  122. GRANT ALL ON opendental.displayreport TO 'user'@'%';
  123. GRANT ALL ON opendental.dispsupply TO 'user'@'%';
  124. GRANT ALL ON opendental.document TO 'user'@'%';
  125. GRANT ALL ON opendental.documentmisc TO 'user'@'%';
  126. GRANT ALL ON opendental.drugmanufacturer TO 'user'@'%';
  127. GRANT ALL ON opendental.drugunit TO 'user'@'%';
  128. GRANT ALL ON opendental.dunning TO 'user'@'%';
  129. GRANT ALL ON opendental.ebill TO 'user'@'%';
  130. GRANT ALL ON opendental.eduresource TO 'user'@'%';
  131. GRANT ALL ON opendental.ehramendment TO 'user'@'%';
  132. GRANT ALL ON opendental.ehraptobs TO 'user'@'%';
  133. GRANT ALL ON opendental.ehrcareplan TO 'user'@'%';
  134. GRANT ALL ON opendental.ehrlab TO 'user'@'%';
  135. GRANT ALL ON opendental.ehrlabclinicalinfo TO 'user'@'%';
  136. GRANT ALL ON opendental.ehrlabimage TO 'user'@'%';
  137. GRANT ALL ON opendental.ehrlabnote TO 'user'@'%';
  138. GRANT ALL ON opendental.ehrlabresult TO 'user'@'%';
  139. GRANT ALL ON opendental.ehrlabresultscopyto TO 'user'@'%';
  140. GRANT ALL ON opendental.ehrlabspecimen TO 'user'@'%';
  141. GRANT ALL ON opendental.ehrlabspecimencondition TO 'user'@'%';
  142. GRANT ALL ON opendental.ehrlabspecimenrejectreason TO 'user'@'%';
  143. GRANT ALL ON opendental.ehrmeasure TO 'user'@'%';
  144. GRANT ALL ON opendental.ehrmeasureevent TO 'user'@'%';
  145. GRANT ALL ON opendental.ehrnotperformed TO 'user'@'%';
  146. GRANT ALL ON opendental.ehrpatient TO 'user'@'%';
  147. GRANT ALL ON opendental.ehrprovkey TO 'user'@'%';
  148. GRANT ALL ON opendental.ehrquarterlykey TO 'user'@'%';
  149. GRANT ALL ON opendental.ehrsummaryccd TO 'user'@'%';
  150. GRANT ALL ON opendental.ehrtrigger TO 'user'@'%';
  151. GRANT ALL ON opendental.electid TO 'user'@'%';
  152. GRANT ALL ON opendental.emailaddress TO 'user'@'%';
  153. GRANT ALL ON opendental.emailattach TO 'user'@'%';
  154. GRANT ALL ON opendental.emailautograph TO 'user'@'%';
  155. GRANT ALL ON opendental.emailmessage TO 'user'@'%';
  156. GRANT ALL ON opendental.emailmessageuid TO 'user'@'%';
  157. GRANT ALL ON opendental.emailtemplate TO 'user'@'%';
  158. GRANT ALL ON opendental.employee TO 'user'@'%';
  159. GRANT ALL ON opendental.employer TO 'user'@'%';
  160. GRANT ALL ON opendental.encounter TO 'user'@'%';
  161. GRANT ALL ON opendental.entrylog TO 'user'@'%';
  162. GRANT ALL ON opendental.eobattach TO 'user'@'%';
  163. GRANT ALL ON opendental.equipment TO 'user'@'%';
  164. GRANT ALL ON opendental.erxlog TO 'user'@'%';
  165. GRANT ALL ON opendental.eservicesignal TO 'user'@'%';
  166. GRANT ALL ON opendental.etrans TO 'user'@'%';
  167. GRANT ALL ON opendental.etrans835attach TO 'user'@'%';
  168. GRANT ALL ON opendental.etransmessagetext TO 'user'@'%';
  169. GRANT ALL ON opendental.evaluation TO 'user'@'%';
  170. GRANT ALL ON opendental.evaluationcriterion TO 'user'@'%';
  171. GRANT ALL ON opendental.evaluationcriteriondef TO 'user'@'%';
  172. GRANT ALL ON opendental.evaluationdef TO 'user'@'%';
  173. GRANT ALL ON opendental.famaging TO 'user'@'%';
  174. GRANT ALL ON opendental.familyhealth TO 'user'@'%';
  175. GRANT ALL ON opendental.fee TO 'user'@'%';
  176. GRANT ALL ON opendental.feesched TO 'user'@'%';
  177. GRANT ALL ON opendental.fhircontactpoint TO 'user'@'%';
  178. GRANT ALL ON opendental.fhirsubscription TO 'user'@'%';
  179. GRANT ALL ON opendental.fielddeflink TO 'user'@'%';
  180. GRANT ALL ON opendental.files TO 'user'@'%';
  181. GRANT ALL ON opendental.formpat TO 'user'@'%';
  182. GRANT ALL ON opendental.gradingscale TO 'user'@'%';
  183. GRANT ALL ON opendental.gradingscaleitem TO 'user'@'%';
  184. GRANT ALL ON opendental.grouppermission TO 'user'@'%';
  185. GRANT ALL ON opendental.guardian TO 'user'@'%';
  186. GRANT ALL ON opendental.hcpcs TO 'user'@'%';
  187. GRANT ALL ON opendental.histappointment TO 'user'@'%';
  188. GRANT ALL ON opendental.hl7def TO 'user'@'%';
  189. GRANT ALL ON opendental.hl7deffield TO 'user'@'%';
  190. GRANT ALL ON opendental.hl7defmessage TO 'user'@'%';
  191. GRANT ALL ON opendental.hl7defsegment TO 'user'@'%';
  192. GRANT ALL ON opendental.hl7msg TO 'user'@'%';
  193. GRANT ALL ON opendental.hl7procattach TO 'user'@'%';
  194. GRANT ALL ON opendental.icd10 TO 'user'@'%';
  195. GRANT ALL ON opendental.icd9 TO 'user'@'%';
  196. GRANT ALL ON opendental.inseditlog TO 'user'@'%';
  197. GRANT ALL ON opendental.insfilingcode TO 'user'@'%';
  198. GRANT ALL ON opendental.insfilingcodesubtype TO 'user'@'%';
  199. GRANT ALL ON opendental.insplan TO 'user'@'%';
  200. GRANT ALL ON opendental.inssub TO 'user'@'%';
  201. GRANT ALL ON opendental.installmentplan TO 'user'@'%';
  202. GRANT ALL ON opendental.instructor TO 'user'@'%';
  203. GRANT ALL ON opendental.insverify TO 'user'@'%';
  204. GRANT ALL ON opendental.insverifyhist TO 'user'@'%';
  205. GRANT ALL ON opendental.intervention TO 'user'@'%';
  206. GRANT ALL ON opendental.journalentry TO 'user'@'%';
  207. GRANT ALL ON opendental.labcase TO 'user'@'%';
  208. GRANT ALL ON opendental.laboratory TO 'user'@'%';
  209. GRANT ALL ON opendental.labpanel TO 'user'@'%';
  210. GRANT ALL ON opendental.labresult TO 'user'@'%';
  211. GRANT ALL ON opendental.labturnaround TO 'user'@'%';
  212. GRANT ALL ON opendental.language TO 'user'@'%';
  213. GRANT ALL ON opendental.languageforeign TO 'user'@'%';
  214. GRANT ALL ON opendental.letter TO 'user'@'%';
  215. GRANT ALL ON opendental.lettermerge TO 'user'@'%';
  216. GRANT ALL ON opendental.lettermergefield TO 'user'@'%';
  217. GRANT ALL ON opendental.loinc TO 'user'@'%';
  218. GRANT ALL ON opendental.maparea TO 'user'@'%';
  219. GRANT ALL ON opendental.medicalorder TO 'user'@'%';
  220. GRANT ALL ON opendental.medication TO 'user'@'%';
  221. GRANT ALL ON opendental.medicationpat TO 'user'@'%';
  222. GRANT ALL ON opendental.medlab TO 'user'@'%';
  223. GRANT ALL ON opendental.medlabfacattach TO 'user'@'%';
  224. GRANT ALL ON opendental.medlabfacility TO 'user'@'%';
  225. GRANT ALL ON opendental.medlabresult TO 'user'@'%';
  226. GRANT ALL ON opendental.medlabspecimen TO 'user'@'%';
  227. GRANT ALL ON opendental.mobileappdevice TO 'user'@'%';
  228. GRANT ALL ON opendental.mount TO 'user'@'%';
  229. GRANT ALL ON opendental.mountdef TO 'user'@'%';
  230. GRANT ALL ON opendental.mountitem TO 'user'@'%';
  231. GRANT ALL ON opendental.mountitemdef TO 'user'@'%';
  232. GRANT ALL ON opendental.oidexternal TO 'user'@'%';
  233. GRANT ALL ON opendental.oidinternal TO 'user'@'%';
  234. GRANT ALL ON opendental.operatory TO 'user'@'%';
  235. GRANT ALL ON opendental.orionproc TO 'user'@'%';
  236. GRANT ALL ON opendental.orthochart TO 'user'@'%';
  237. GRANT ALL ON opendental.orthocharttab TO 'user'@'%';
  238. GRANT ALL ON opendental.orthocharttablink TO 'user'@'%';
  239. GRANT ALL ON opendental.patfield TO 'user'@'%';
  240. GRANT ALL ON opendental.patfielddef TO 'user'@'%';
  241. GRANT ALL ON opendental.patient TO 'user'@'%';
  242. GRANT ALL ON opendental.patientlink TO 'user'@'%';
  243. GRANT ALL ON opendental.patientnote TO 'user'@'%';
  244. GRANT ALL ON opendental.patientportalinvite TO 'user'@'%';
  245. GRANT ALL ON opendental.patientrace TO 'user'@'%';
  246. GRANT ALL ON opendental.patplan TO 'user'@'%';
  247. GRANT ALL ON opendental.patrestriction TO 'user'@'%';
  248. GRANT ALL ON opendental.payconnectresponseweb TO 'user'@'%';
  249. GRANT ALL ON opendental.payment TO 'user'@'%';
  250. GRANT ALL ON opendental.payortype TO 'user'@'%';
  251. GRANT ALL ON opendental.payperiod TO 'user'@'%';
  252. GRANT ALL ON opendental.payplan TO 'user'@'%';
  253. GRANT ALL ON opendental.payplancharge TO 'user'@'%';
  254. GRANT ALL ON opendental.paysplit TO 'user'@'%';
  255. GRANT ALL ON opendental.perioexam TO 'user'@'%';
  256. GRANT ALL ON opendental.periomeasure TO 'user'@'%';
  257. GRANT ALL ON opendental.pharmacy TO 'user'@'%';
  258. GRANT ALL ON opendental.pharmclinic TO 'user'@'%';
  259. GRANT ALL ON opendental.phonenumber TO 'user'@'%';
  260. GRANT ALL ON opendental.plannedappt TO 'user'@'%';
  261. GRANT ALL ON opendental.popup TO 'user'@'%';
  262. GRANT ALL ON opendental.preference TO 'user'@'%';
  263. GRANT ALL ON opendental.printer TO 'user'@'%';
  264. GRANT ALL ON opendental.procapptcolor TO 'user'@'%';
  265. GRANT ALL ON opendental.procbutton TO 'user'@'%';
  266. GRANT ALL ON opendental.procbuttonitem TO 'user'@'%';
  267. GRANT ALL ON opendental.procbuttonquick TO 'user'@'%';
  268. GRANT ALL ON opendental.proccodenote TO 'user'@'%';
  269. GRANT ALL ON opendental.procedurecode TO 'user'@'%';
  270. GRANT ALL ON opendental.procgroupitem TO 'user'@'%';
  271. GRANT ALL ON opendental.procmultivisit TO 'user'@'%';
  272. GRANT ALL ON opendental.procnote TO 'user'@'%';
  273. GRANT ALL ON opendental.proctp TO 'user'@'%';
  274. GRANT ALL ON opendental.program TO 'user'@'%';
  275. GRANT ALL ON opendental.programproperty TO 'user'@'%';
  276. GRANT ALL ON opendental.provider TO 'user'@'%';
  277. GRANT ALL ON opendental.providerclinic TO 'user'@'%';
  278. GRANT ALL ON opendental.providercliniclink TO 'user'@'%';
  279. GRANT ALL ON opendental.providererx TO 'user'@'%';
  280. GRANT ALL ON opendental.providerident TO 'user'@'%';
  281. GRANT ALL ON opendental.question TO 'user'@'%';
  282. GRANT ALL ON opendental.questiondef TO 'user'@'%';
  283. GRANT ALL ON opendental.quickpastecat TO 'user'@'%';
  284. GRANT ALL ON opendental.quickpastenote TO 'user'@'%';
  285. GRANT ALL ON opendental.reactivation TO 'user'@'%';
  286. GRANT ALL ON opendental.recall TO 'user'@'%';
  287. GRANT ALL ON opendental.recalltrigger TO 'user'@'%';
  288. GRANT ALL ON opendental.recalltype TO 'user'@'%';
  289. GRANT ALL ON opendental.reconcile TO 'user'@'%';
  290. GRANT ALL ON opendental.recurringcharge TO 'user'@'%';
  291. GRANT ALL ON opendental.refattach TO 'user'@'%';
  292. GRANT ALL ON opendental.referral TO 'user'@'%';
  293. GRANT ALL ON opendental.registrationkey TO 'user'@'%';
  294. GRANT ALL ON opendental.reminderrule TO 'user'@'%';
  295. GRANT ALL ON opendental.repeatcharge TO 'user'@'%';
  296. GRANT ALL ON opendental.replicationserver TO 'user'@'%';
  297. GRANT ALL ON opendental.reqneeded TO 'user'@'%';
  298. GRANT ALL ON opendental.reqstudent TO 'user'@'%';
  299. GRANT ALL ON opendental.requiredfield TO 'user'@'%';
  300. GRANT ALL ON opendental.requiredfieldcondition TO 'user'@'%';
  301. GRANT ALL ON opendental.reseller TO 'user'@'%';
  302. GRANT ALL ON opendental.resellerservice TO 'user'@'%';
  303. GRANT ALL ON opendental.rxalert TO 'user'@'%';
  304. GRANT ALL ON opendental.rxdef TO 'user'@'%';
  305. GRANT ALL ON opendental.rxnorm TO 'user'@'%';
  306. GRANT ALL ON opendental.rxpat TO 'user'@'%';
  307. GRANT ALL ON opendental.schedule TO 'user'@'%';
  308. GRANT ALL ON opendental.scheduleop TO 'user'@'%';
  309. GRANT ALL ON opendental.schoolclass TO 'user'@'%';
  310. GRANT ALL ON opendental.schoolcourse TO 'user'@'%';
  311. GRANT ALL ON opendental.screen TO 'user'@'%';
  312. GRANT ALL ON opendental.screengroup TO 'user'@'%';
  313. GRANT ALL ON opendental.screenpat TO 'user'@'%';
  314. GRANT ALL ON opendental.securitylog TO 'user'@'%';
  315. GRANT ALL ON opendental.securityloghash TO 'user'@'%';
  316. GRANT ALL ON opendental.sheet TO 'user'@'%';
  317. GRANT ALL ON opendental.sheetdef TO 'user'@'%';
  318. GRANT ALL ON opendental.sheetfield TO 'user'@'%';
  319. GRANT ALL ON opendental.sheetfielddef TO 'user'@'%';
  320. GRANT ALL ON opendental.sigbutdef TO 'user'@'%';
  321. GRANT ALL ON opendental.sigelementdef TO 'user'@'%';
  322. GRANT ALL ON opendental.sigmessage TO 'user'@'%';
  323. GRANT ALL ON opendental.signalod TO 'user'@'%';
  324. GRANT ALL ON opendental.site TO 'user'@'%';
  325. GRANT ALL ON opendental.smsblockphone TO 'user'@'%';
  326. GRANT ALL ON opendental.smsfrommobile TO 'user'@'%';
  327. GRANT ALL ON opendental.smsphone TO 'user'@'%';
  328. GRANT ALL ON opendental.smstomobile TO 'user'@'%';
  329. GRANT ALL ON opendental.snomed TO 'user'@'%';
  330. GRANT ALL ON opendental.sop TO 'user'@'%';
  331. GRANT ALL ON opendental.stateabbr TO 'user'@'%';
  332. GRANT ALL ON opendental.statement TO 'user'@'%';
  333. GRANT ALL ON opendental.stmtlink TO 'user'@'%';
  334. GRANT ALL ON opendental.substitutionlink TO 'user'@'%';
  335. GRANT ALL ON opendental.supplier TO 'user'@'%';
  336. GRANT ALL ON opendental.supply TO 'user'@'%';
  337. GRANT ALL ON opendental.supplyneeded TO 'user'@'%';
  338. GRANT ALL ON opendental.supplyorder TO 'user'@'%';
  339. GRANT ALL ON opendental.supplyorderitem TO 'user'@'%';
  340. GRANT ALL ON opendental.task TO 'user'@'%';
  341. GRANT ALL ON opendental.taskancestor TO 'user'@'%';
  342. GRANT ALL ON opendental.taskhist TO 'user'@'%';
  343. GRANT ALL ON opendental.tasklist TO 'user'@'%';
  344. GRANT ALL ON opendental.tasknote TO 'user'@'%';
  345. GRANT ALL ON opendental.tasksubscription TO 'user'@'%';
  346. GRANT ALL ON opendental.taskunread TO 'user'@'%';
  347. GRANT ALL ON opendental.terminalactive TO 'user'@'%';
  348. GRANT ALL ON opendental.timeadjust TO 'user'@'%';
  349. GRANT ALL ON opendental.timecardrule TO 'user'@'%';
  350. GRANT ALL ON opendental.toolbutitem TO 'user'@'%';
  351. GRANT ALL ON opendental.toothgridcell TO 'user'@'%';
  352. GRANT ALL ON opendental.toothgridcol TO 'user'@'%';
  353. GRANT ALL ON opendental.toothgriddef TO 'user'@'%';
  354. GRANT ALL ON opendental.toothinitial TO 'user'@'%';
  355. GRANT ALL ON opendental.transaction TO 'user'@'%';
  356. GRANT ALL ON opendental.treatplan TO 'user'@'%';
  357. GRANT ALL ON opendental.treatplanattach TO 'user'@'%';
  358. GRANT ALL ON opendental.tsitranslog TO 'user'@'%';
  359. GRANT ALL ON opendental.ucum TO 'user'@'%';
  360. GRANT ALL ON opendental.updatehistory TO 'user'@'%';
  361. GRANT ALL ON opendental.userclinic TO 'user'@'%';
  362. GRANT ALL ON opendental.usergroup TO 'user'@'%';
  363. GRANT ALL ON opendental.usergroupattach TO 'user'@'%';
  364. GRANT ALL ON opendental.userod TO 'user'@'%';
  365. GRANT ALL ON opendental.userodapptview TO 'user'@'%';
  366. GRANT ALL ON opendental.userodpref TO 'user'@'%';
  367. GRANT ALL ON opendental.userquery TO 'user'@'%';
  368. GRANT ALL ON opendental.userweb TO 'user'@'%';
  369. GRANT ALL ON opendental.vaccinedef TO 'user'@'%';
  370. GRANT ALL ON opendental.vaccineobs TO 'user'@'%';
  371. GRANT ALL ON opendental.vaccinepat TO 'user'@'%';
  372. GRANT ALL ON opendental.vitalsign TO 'user'@'%';
  373. GRANT ALL ON opendental.webschedrecall TO 'user'@'%';
  374. GRANT ALL ON opendental.wikilistheaderwidth TO 'user'@'%';
  375. GRANT ALL ON opendental.wikilisthist TO 'user'@'%';
  376. GRANT ALL ON opendental.wikipage TO 'user'@'%';
  377. GRANT ALL ON opendental.wikipagehist TO 'user'@'%';
  378. GRANT ALL ON opendental.xchargetransaction TO 'user'@'%';
  379. GRANT ALL ON opendental.xwebresponse TO 'user'@'%';
  380. GRANT ALL ON opendental.zipcode TO 'user'@'%';
  381. GRANT SELECT, SELECT (RepeatChargeNum, ProvNum, DateTP, ProcNum, ClaimNote, AptNum, DiagnosticCode, DateOriginalProsth, OrderingReferralNum, ProcTimeEnd, BaseUnits, Prosthesis, CanadianTypeCodes, Surf, StatementNum, ProcStatus, DrugUnit, IcdVersion, ToothRange, ToothNum, ProvOrderOverride, BillingTypeTwo, PlaceService, SnomedBodySite, IsLocked, ProcTime, DateComplete, Priority, TaxAmt, IsCpoe, DiagnosticCode4, OldCode, ProcNumLab, ClinicNum, ProcDate, CodeMod3, StartTime, CodeNum, Discount, SiteNum, StopTime, MedicalCode, PatNum, UnitQty, IsPrincDiag, Prognosis, IsDateProsthEst, CodeMod2, BillingNote, UnitQtyType, CodeMod1, DateEntryC, RevCode, DateTStamp, CodeMod4, PlannedAptNum, SecUserNumEntry, BillingTypeOne, SecDateEntry, HideGraphics, DiagnosticCode3, Dx, DiagnosticCode2, DrugQty, ProcFee), INSERT, UPDATE (RepeatChargeNum, ProvNum, DateTP, ProcNum, ClaimNote, AptNum, DiagnosticCode, DateOriginalProsth, OrderingReferralNum, ProcTimeEnd, BaseUnits, Prosthesis, CanadianTypeCodes, Surf, StatementNum, ProcStatus, DrugUnit, IcdVersion, ToothRange, ToothNum, ProvOrderOverride, BillingTypeTwo, PlaceService, SnomedBodySite, IsLocked, ProcTime, DateComplete, Priority, TaxAmt, IsCpoe, DiagnosticCode4, OldCode, ProcNumLab, ClinicNum, ProcDate, CodeMod3, StartTime, CodeNum, Discount, SiteNum, StopTime, MedicalCode, PatNum, UnitQty, IsPrincDiag, Prognosis, IsDateProsthEst, CodeMod2, BillingNote, UnitQtyType, CodeMod1, DateEntryC, RevCode, CodeMod4, PlannedAptNum, SecUserNumEntry, BillingTypeOne, SecDateEntry, HideGraphics, DiagnosticCode3, Dx, DiagnosticCode2, DrugQty, ProcFee), DELETE, SHOW VIEW ON `opendental`.`procedurelog` TO 'user'@'%';
  382.  
  383. GRANT ALL ON opendental.account TO 'user'@'127.0.0.1';
  384. GRANT ALL ON opendental.accountingautopay TO 'user'@'127.0.0.1';
  385. GRANT ALL ON opendental.adjustment TO 'user'@'127.0.0.1';
  386. GRANT ALL ON opendental.alertcategory TO 'user'@'127.0.0.1';
  387. GRANT ALL ON opendental.alertcategorylink TO 'user'@'127.0.0.1';
  388. GRANT ALL ON opendental.alertitem TO 'user'@'127.0.0.1';
  389. GRANT ALL ON opendental.alertread TO 'user'@'127.0.0.1';
  390. GRANT ALL ON opendental.alertsub TO 'user'@'127.0.0.1';
  391. GRANT ALL ON opendental.allergy TO 'user'@'127.0.0.1';
  392. GRANT ALL ON opendental.allergydef TO 'user'@'127.0.0.1';
  393. GRANT ALL ON opendental.anestheticdata TO 'user'@'127.0.0.1';
  394. GRANT ALL ON opendental.anestheticrecord TO 'user'@'127.0.0.1';
  395. GRANT ALL ON opendental.anesthmedsgiven TO 'user'@'127.0.0.1';
  396. GRANT ALL ON opendental.anesthmedsintake TO 'user'@'127.0.0.1';
  397. GRANT ALL ON opendental.anesthmedsinventory TO 'user'@'127.0.0.1';
  398. GRANT ALL ON opendental.anesthmedsinventoryadj TO 'user'@'127.0.0.1';
  399. GRANT ALL ON opendental.anesthmedsuppliers TO 'user'@'127.0.0.1';
  400. GRANT ALL ON opendental.anesthscore TO 'user'@'127.0.0.1';
  401. GRANT ALL ON opendental.anesthvsdata TO 'user'@'127.0.0.1';
  402. GRANT ALL ON opendental.appointment TO 'user'@'127.0.0.1';
  403. GRANT ALL ON opendental.appointmentrule TO 'user'@'127.0.0.1';
  404. GRANT ALL ON opendental.appointmenttype TO 'user'@'127.0.0.1';
  405. GRANT ALL ON opendental.apptfield TO 'user'@'127.0.0.1';
  406. GRANT ALL ON opendental.apptfielddef TO 'user'@'127.0.0.1';
  407. GRANT ALL ON opendental.apptreminderrule TO 'user'@'127.0.0.1';
  408. GRANT ALL ON opendental.apptremindersent TO 'user'@'127.0.0.1';
  409. GRANT ALL ON opendental.apptview TO 'user'@'127.0.0.1';
  410. GRANT ALL ON opendental.apptviewitem TO 'user'@'127.0.0.1';
  411. GRANT ALL ON opendental.asapcomm TO 'user'@'127.0.0.1';
  412. GRANT ALL ON opendental.autocode TO 'user'@'127.0.0.1';
  413. GRANT ALL ON opendental.autocodecond TO 'user'@'127.0.0.1';
  414. GRANT ALL ON opendental.autocodeitem TO 'user'@'127.0.0.1';
  415. GRANT ALL ON opendental.automation TO 'user'@'127.0.0.1';
  416. GRANT ALL ON opendental.automationcondition TO 'user'@'127.0.0.1';
  417. GRANT ALL ON opendental.autonote TO 'user'@'127.0.0.1';
  418. GRANT ALL ON opendental.autonotecontrol TO 'user'@'127.0.0.1';
  419. GRANT ALL ON opendental.benefit TO 'user'@'127.0.0.1';
  420. GRANT ALL ON opendental.canadiannetwork TO 'user'@'127.0.0.1';
  421. GRANT ALL ON opendental.carrier TO 'user'@'127.0.0.1';
  422. GRANT ALL ON opendental.cdcrec TO 'user'@'127.0.0.1';
  423. GRANT ALL ON opendental.cdspermission TO 'user'@'127.0.0.1';
  424. GRANT ALL ON opendental.centralconnection TO 'user'@'127.0.0.1';
  425. GRANT ALL ON opendental.chartview TO 'user'@'127.0.0.1';
  426. GRANT ALL ON opendental.claim TO 'user'@'127.0.0.1';
  427. GRANT ALL ON opendental.claimattach TO 'user'@'127.0.0.1';
  428. GRANT ALL ON opendental.claimcondcodelog TO 'user'@'127.0.0.1';
  429. GRANT ALL ON opendental.claimform TO 'user'@'127.0.0.1';
  430. GRANT ALL ON opendental.claimformitem TO 'user'@'127.0.0.1';
  431. GRANT ALL ON opendental.claimpayment TO 'user'@'127.0.0.1';
  432. GRANT ALL ON opendental.claimproc TO 'user'@'127.0.0.1';
  433. GRANT ALL ON opendental.claimsnapshot TO 'user'@'127.0.0.1';
  434. GRANT ALL ON opendental.claimtracking TO 'user'@'127.0.0.1';
  435. GRANT ALL ON opendental.claimvalcodelog TO 'user'@'127.0.0.1';
  436. GRANT ALL ON opendental.clearinghouse TO 'user'@'127.0.0.1';
  437. GRANT ALL ON opendental.clinic TO 'user'@'127.0.0.1';
  438. GRANT ALL ON opendental.clinicerx TO 'user'@'127.0.0.1';
  439. GRANT ALL ON opendental.clinicpref TO 'user'@'127.0.0.1';
  440. GRANT ALL ON opendental.clockevent TO 'user'@'127.0.0.1';
  441. GRANT ALL ON opendental.codesystem TO 'user'@'127.0.0.1';
  442. GRANT ALL ON opendental.commlog TO 'user'@'127.0.0.1';
  443. GRANT ALL ON opendental.commoptout TO 'user'@'127.0.0.1';
  444. GRANT ALL ON opendental.computer TO 'user'@'127.0.0.1';
  445. GRANT ALL ON opendental.computerpref TO 'user'@'127.0.0.1';
  446. GRANT ALL ON opendental.confirmationrequest TO 'user'@'127.0.0.1';
  447. GRANT ALL ON opendental.connectiongroup TO 'user'@'127.0.0.1';
  448. GRANT ALL ON opendental.conngroupattach TO 'user'@'127.0.0.1';
  449. GRANT ALL ON opendental.contact TO 'user'@'127.0.0.1';
  450. GRANT ALL ON opendental.county TO 'user'@'127.0.0.1';
  451. GRANT ALL ON opendental.covcat TO 'user'@'127.0.0.1';
  452. GRANT ALL ON opendental.covspan TO 'user'@'127.0.0.1';
  453. GRANT ALL ON opendental.cpt TO 'user'@'127.0.0.1';
  454. GRANT ALL ON opendental.creditcard TO 'user'@'127.0.0.1';
  455. GRANT ALL ON opendental.custrefentry TO 'user'@'127.0.0.1';
  456. GRANT ALL ON opendental.custreference TO 'user'@'127.0.0.1';
  457. GRANT ALL ON opendental.cvx TO 'user'@'127.0.0.1';
  458. GRANT ALL ON opendental.dashboardar TO 'user'@'127.0.0.1';
  459. GRANT ALL ON opendental.dashboardcell TO 'user'@'127.0.0.1';
  460. GRANT ALL ON opendental.dashboardlayout TO 'user'@'127.0.0.1';
  461. GRANT ALL ON opendental.databasemaintenance TO 'user'@'127.0.0.1';
  462. GRANT ALL ON opendental.dbmlog TO 'user'@'127.0.0.1';
  463. GRANT ALL ON opendental.definition TO 'user'@'127.0.0.1';
  464. GRANT ALL ON opendental.deflink TO 'user'@'127.0.0.1';
  465. GRANT ALL ON opendental.deletedobject TO 'user'@'127.0.0.1';
  466. GRANT ALL ON opendental.deposit TO 'user'@'127.0.0.1';
  467. GRANT ALL ON opendental.dictcustom TO 'user'@'127.0.0.1';
  468. GRANT ALL ON opendental.discountplan TO 'user'@'127.0.0.1';
  469. GRANT ALL ON opendental.disease TO 'user'@'127.0.0.1';
  470. GRANT ALL ON opendental.diseasedef TO 'user'@'127.0.0.1';
  471. GRANT ALL ON opendental.displayfield TO 'user'@'127.0.0.1';
  472. GRANT ALL ON opendental.displayreport TO 'user'@'127.0.0.1';
  473. GRANT ALL ON opendental.dispsupply TO 'user'@'127.0.0.1';
  474. GRANT ALL ON opendental.document TO 'user'@'127.0.0.1';
  475. GRANT ALL ON opendental.documentmisc TO 'user'@'127.0.0.1';
  476. GRANT ALL ON opendental.drugmanufacturer TO 'user'@'127.0.0.1';
  477. GRANT ALL ON opendental.drugunit TO 'user'@'127.0.0.1';
  478. GRANT ALL ON opendental.dunning TO 'user'@'127.0.0.1';
  479. GRANT ALL ON opendental.ebill TO 'user'@'127.0.0.1';
  480. GRANT ALL ON opendental.eduresource TO 'user'@'127.0.0.1';
  481. GRANT ALL ON opendental.ehramendment TO 'user'@'127.0.0.1';
  482. GRANT ALL ON opendental.ehraptobs TO 'user'@'127.0.0.1';
  483. GRANT ALL ON opendental.ehrcareplan TO 'user'@'127.0.0.1';
  484. GRANT ALL ON opendental.ehrlab TO 'user'@'127.0.0.1';
  485. GRANT ALL ON opendental.ehrlabclinicalinfo TO 'user'@'127.0.0.1';
  486. GRANT ALL ON opendental.ehrlabimage TO 'user'@'127.0.0.1';
  487. GRANT ALL ON opendental.ehrlabnote TO 'user'@'127.0.0.1';
  488. GRANT ALL ON opendental.ehrlabresult TO 'user'@'127.0.0.1';
  489. GRANT ALL ON opendental.ehrlabresultscopyto TO 'user'@'127.0.0.1';
  490. GRANT ALL ON opendental.ehrlabspecimen TO 'user'@'127.0.0.1';
  491. GRANT ALL ON opendental.ehrlabspecimencondition TO 'user'@'127.0.0.1';
  492. GRANT ALL ON opendental.ehrlabspecimenrejectreason TO 'user'@'127.0.0.1';
  493. GRANT ALL ON opendental.ehrmeasure TO 'user'@'127.0.0.1';
  494. GRANT ALL ON opendental.ehrmeasureevent TO 'user'@'127.0.0.1';
  495. GRANT ALL ON opendental.ehrnotperformed TO 'user'@'127.0.0.1';
  496. GRANT ALL ON opendental.ehrpatient TO 'user'@'127.0.0.1';
  497. GRANT ALL ON opendental.ehrprovkey TO 'user'@'127.0.0.1';
  498. GRANT ALL ON opendental.ehrquarterlykey TO 'user'@'127.0.0.1';
  499. GRANT ALL ON opendental.ehrsummaryccd TO 'user'@'127.0.0.1';
  500. GRANT ALL ON opendental.ehrtrigger TO 'user'@'127.0.0.1';
  501. GRANT ALL ON opendental.electid TO 'user'@'127.0.0.1';
  502. GRANT ALL ON opendental.emailaddress TO 'user'@'127.0.0.1';
  503. GRANT ALL ON opendental.emailattach TO 'user'@'127.0.0.1';
  504. GRANT ALL ON opendental.emailautograph TO 'user'@'127.0.0.1';
  505. GRANT ALL ON opendental.emailmessage TO 'user'@'127.0.0.1';
  506. GRANT ALL ON opendental.emailmessageuid TO 'user'@'127.0.0.1';
  507. GRANT ALL ON opendental.emailtemplate TO 'user'@'127.0.0.1';
  508. GRANT ALL ON opendental.employee TO 'user'@'127.0.0.1';
  509. GRANT ALL ON opendental.employer TO 'user'@'127.0.0.1';
  510. GRANT ALL ON opendental.encounter TO 'user'@'127.0.0.1';
  511. GRANT ALL ON opendental.entrylog TO 'user'@'127.0.0.1';
  512. GRANT ALL ON opendental.eobattach TO 'user'@'127.0.0.1';
  513. GRANT ALL ON opendental.equipment TO 'user'@'127.0.0.1';
  514. GRANT ALL ON opendental.erxlog TO 'user'@'127.0.0.1';
  515. GRANT ALL ON opendental.eservicesignal TO 'user'@'127.0.0.1';
  516. GRANT ALL ON opendental.etrans TO 'user'@'127.0.0.1';
  517. GRANT ALL ON opendental.etrans835attach TO 'user'@'127.0.0.1';
  518. GRANT ALL ON opendental.etransmessagetext TO 'user'@'127.0.0.1';
  519. GRANT ALL ON opendental.evaluation TO 'user'@'127.0.0.1';
  520. GRANT ALL ON opendental.evaluationcriterion TO 'user'@'127.0.0.1';
  521. GRANT ALL ON opendental.evaluationcriteriondef TO 'user'@'127.0.0.1';
  522. GRANT ALL ON opendental.evaluationdef TO 'user'@'127.0.0.1';
  523. GRANT ALL ON opendental.famaging TO 'user'@'127.0.0.1';
  524. GRANT ALL ON opendental.familyhealth TO 'user'@'127.0.0.1';
  525. GRANT ALL ON opendental.fee TO 'user'@'127.0.0.1';
  526. GRANT ALL ON opendental.feesched TO 'user'@'127.0.0.1';
  527. GRANT ALL ON opendental.fhircontactpoint TO 'user'@'127.0.0.1';
  528. GRANT ALL ON opendental.fhirsubscription TO 'user'@'127.0.0.1';
  529. GRANT ALL ON opendental.fielddeflink TO 'user'@'127.0.0.1';
  530. GRANT ALL ON opendental.files TO 'user'@'127.0.0.1';
  531. GRANT ALL ON opendental.formpat TO 'user'@'127.0.0.1';
  532. GRANT ALL ON opendental.gradingscale TO 'user'@'127.0.0.1';
  533. GRANT ALL ON opendental.gradingscaleitem TO 'user'@'127.0.0.1';
  534. GRANT ALL ON opendental.grouppermission TO 'user'@'127.0.0.1';
  535. GRANT ALL ON opendental.guardian TO 'user'@'127.0.0.1';
  536. GRANT ALL ON opendental.hcpcs TO 'user'@'127.0.0.1';
  537. GRANT ALL ON opendental.histappointment TO 'user'@'127.0.0.1';
  538. GRANT ALL ON opendental.hl7def TO 'user'@'127.0.0.1';
  539. GRANT ALL ON opendental.hl7deffield TO 'user'@'127.0.0.1';
  540. GRANT ALL ON opendental.hl7defmessage TO 'user'@'127.0.0.1';
  541. GRANT ALL ON opendental.hl7defsegment TO 'user'@'127.0.0.1';
  542. GRANT ALL ON opendental.hl7msg TO 'user'@'127.0.0.1';
  543. GRANT ALL ON opendental.hl7procattach TO 'user'@'127.0.0.1';
  544. GRANT ALL ON opendental.icd10 TO 'user'@'127.0.0.1';
  545. GRANT ALL ON opendental.icd9 TO 'user'@'127.0.0.1';
  546. GRANT ALL ON opendental.inseditlog TO 'user'@'127.0.0.1';
  547. GRANT ALL ON opendental.insfilingcode TO 'user'@'127.0.0.1';
  548. GRANT ALL ON opendental.insfilingcodesubtype TO 'user'@'127.0.0.1';
  549. GRANT ALL ON opendental.insplan TO 'user'@'127.0.0.1';
  550. GRANT ALL ON opendental.inssub TO 'user'@'127.0.0.1';
  551. GRANT ALL ON opendental.installmentplan TO 'user'@'127.0.0.1';
  552. GRANT ALL ON opendental.instructor TO 'user'@'127.0.0.1';
  553. GRANT ALL ON opendental.insverify TO 'user'@'127.0.0.1';
  554. GRANT ALL ON opendental.insverifyhist TO 'user'@'127.0.0.1';
  555. GRANT ALL ON opendental.intervention TO 'user'@'127.0.0.1';
  556. GRANT ALL ON opendental.journalentry TO 'user'@'127.0.0.1';
  557. GRANT ALL ON opendental.labcase TO 'user'@'127.0.0.1';
  558. GRANT ALL ON opendental.laboratory TO 'user'@'127.0.0.1';
  559. GRANT ALL ON opendental.labpanel TO 'user'@'127.0.0.1';
  560. GRANT ALL ON opendental.labresult TO 'user'@'127.0.0.1';
  561. GRANT ALL ON opendental.labturnaround TO 'user'@'127.0.0.1';
  562. GRANT ALL ON opendental.language TO 'user'@'127.0.0.1';
  563. GRANT ALL ON opendental.languageforeign TO 'user'@'127.0.0.1';
  564. GRANT ALL ON opendental.letter TO 'user'@'127.0.0.1';
  565. GRANT ALL ON opendental.lettermerge TO 'user'@'127.0.0.1';
  566. GRANT ALL ON opendental.lettermergefield TO 'user'@'127.0.0.1';
  567. GRANT ALL ON opendental.loinc TO 'user'@'127.0.0.1';
  568. GRANT ALL ON opendental.maparea TO 'user'@'127.0.0.1';
  569. GRANT ALL ON opendental.medicalorder TO 'user'@'127.0.0.1';
  570. GRANT ALL ON opendental.medication TO 'user'@'127.0.0.1';
  571. GRANT ALL ON opendental.medicationpat TO 'user'@'127.0.0.1';
  572. GRANT ALL ON opendental.medlab TO 'user'@'127.0.0.1';
  573. GRANT ALL ON opendental.medlabfacattach TO 'user'@'127.0.0.1';
  574. GRANT ALL ON opendental.medlabfacility TO 'user'@'127.0.0.1';
  575. GRANT ALL ON opendental.medlabresult TO 'user'@'127.0.0.1';
  576. GRANT ALL ON opendental.medlabspecimen TO 'user'@'127.0.0.1';
  577. GRANT ALL ON opendental.mobileappdevice TO 'user'@'127.0.0.1';
  578. GRANT ALL ON opendental.mount TO 'user'@'127.0.0.1';
  579. GRANT ALL ON opendental.mountdef TO 'user'@'127.0.0.1';
  580. GRANT ALL ON opendental.mountitem TO 'user'@'127.0.0.1';
  581. GRANT ALL ON opendental.mountitemdef TO 'user'@'127.0.0.1';
  582. GRANT ALL ON opendental.oidexternal TO 'user'@'127.0.0.1';
  583. GRANT ALL ON opendental.oidinternal TO 'user'@'127.0.0.1';
  584. GRANT ALL ON opendental.operatory TO 'user'@'127.0.0.1';
  585. GRANT ALL ON opendental.orionproc TO 'user'@'127.0.0.1';
  586. GRANT ALL ON opendental.orthochart TO 'user'@'127.0.0.1';
  587. GRANT ALL ON opendental.orthocharttab TO 'user'@'127.0.0.1';
  588. GRANT ALL ON opendental.orthocharttablink TO 'user'@'127.0.0.1';
  589. GRANT ALL ON opendental.patfield TO 'user'@'127.0.0.1';
  590. GRANT ALL ON opendental.patfielddef TO 'user'@'127.0.0.1';
  591. GRANT ALL ON opendental.patient TO 'user'@'127.0.0.1';
  592. GRANT ALL ON opendental.patientlink TO 'user'@'127.0.0.1';
  593. GRANT ALL ON opendental.patientnote TO 'user'@'127.0.0.1';
  594. GRANT ALL ON opendental.patientportalinvite TO 'user'@'127.0.0.1';
  595. GRANT ALL ON opendental.patientrace TO 'user'@'127.0.0.1';
  596. GRANT ALL ON opendental.patplan TO 'user'@'127.0.0.1';
  597. GRANT ALL ON opendental.patrestriction TO 'user'@'127.0.0.1';
  598. GRANT ALL ON opendental.payconnectresponseweb TO 'user'@'127.0.0.1';
  599. GRANT ALL ON opendental.payment TO 'user'@'127.0.0.1';
  600. GRANT ALL ON opendental.payortype TO 'user'@'127.0.0.1';
  601. GRANT ALL ON opendental.payperiod TO 'user'@'127.0.0.1';
  602. GRANT ALL ON opendental.payplan TO 'user'@'127.0.0.1';
  603. GRANT ALL ON opendental.payplancharge TO 'user'@'127.0.0.1';
  604. GRANT ALL ON opendental.paysplit TO 'user'@'127.0.0.1';
  605. GRANT ALL ON opendental.perioexam TO 'user'@'127.0.0.1';
  606. GRANT ALL ON opendental.periomeasure TO 'user'@'127.0.0.1';
  607. GRANT ALL ON opendental.pharmacy TO 'user'@'127.0.0.1';
  608. GRANT ALL ON opendental.pharmclinic TO 'user'@'127.0.0.1';
  609. GRANT ALL ON opendental.phonenumber TO 'user'@'127.0.0.1';
  610. GRANT ALL ON opendental.plannedappt TO 'user'@'127.0.0.1';
  611. GRANT ALL ON opendental.popup TO 'user'@'127.0.0.1';
  612. GRANT ALL ON opendental.preference TO 'user'@'127.0.0.1';
  613. GRANT ALL ON opendental.printer TO 'user'@'127.0.0.1';
  614. GRANT ALL ON opendental.procapptcolor TO 'user'@'127.0.0.1';
  615. GRANT ALL ON opendental.procbutton TO 'user'@'127.0.0.1';
  616. GRANT ALL ON opendental.procbuttonitem TO 'user'@'127.0.0.1';
  617. GRANT ALL ON opendental.procbuttonquick TO 'user'@'127.0.0.1';
  618. GRANT ALL ON opendental.proccodenote TO 'user'@'127.0.0.1';
  619. GRANT ALL ON opendental.procedurecode TO 'user'@'127.0.0.1';
  620. GRANT ALL ON opendental.procgroupitem TO 'user'@'127.0.0.1';
  621. GRANT ALL ON opendental.procmultivisit TO 'user'@'127.0.0.1';
  622. GRANT ALL ON opendental.procnote TO 'user'@'127.0.0.1';
  623. GRANT ALL ON opendental.proctp TO 'user'@'127.0.0.1';
  624. GRANT ALL ON opendental.program TO 'user'@'127.0.0.1';
  625. GRANT ALL ON opendental.programproperty TO 'user'@'127.0.0.1';
  626. GRANT ALL ON opendental.provider TO 'user'@'127.0.0.1';
  627. GRANT ALL ON opendental.providerclinic TO 'user'@'127.0.0.1';
  628. GRANT ALL ON opendental.providercliniclink TO 'user'@'127.0.0.1';
  629. GRANT ALL ON opendental.providererx TO 'user'@'127.0.0.1';
  630. GRANT ALL ON opendental.providerident TO 'user'@'127.0.0.1';
  631. GRANT ALL ON opendental.question TO 'user'@'127.0.0.1';
  632. GRANT ALL ON opendental.questiondef TO 'user'@'127.0.0.1';
  633. GRANT ALL ON opendental.quickpastecat TO 'user'@'127.0.0.1';
  634. GRANT ALL ON opendental.quickpastenote TO 'user'@'127.0.0.1';
  635. GRANT ALL ON opendental.reactivation TO 'user'@'127.0.0.1';
  636. GRANT ALL ON opendental.recall TO 'user'@'127.0.0.1';
  637. GRANT ALL ON opendental.recalltrigger TO 'user'@'127.0.0.1';
  638. GRANT ALL ON opendental.recalltype TO 'user'@'127.0.0.1';
  639. GRANT ALL ON opendental.reconcile TO 'user'@'127.0.0.1';
  640. GRANT ALL ON opendental.recurringcharge TO 'user'@'127.0.0.1';
  641. GRANT ALL ON opendental.refattach TO 'user'@'127.0.0.1';
  642. GRANT ALL ON opendental.referral TO 'user'@'127.0.0.1';
  643. GRANT ALL ON opendental.registrationkey TO 'user'@'127.0.0.1';
  644. GRANT ALL ON opendental.reminderrule TO 'user'@'127.0.0.1';
  645. GRANT ALL ON opendental.repeatcharge TO 'user'@'127.0.0.1';
  646. GRANT ALL ON opendental.replicationserver TO 'user'@'127.0.0.1';
  647. GRANT ALL ON opendental.reqneeded TO 'user'@'127.0.0.1';
  648. GRANT ALL ON opendental.reqstudent TO 'user'@'127.0.0.1';
  649. GRANT ALL ON opendental.requiredfield TO 'user'@'127.0.0.1';
  650. GRANT ALL ON opendental.requiredfieldcondition TO 'user'@'127.0.0.1';
  651. GRANT ALL ON opendental.reseller TO 'user'@'127.0.0.1';
  652. GRANT ALL ON opendental.resellerservice TO 'user'@'127.0.0.1';
  653. GRANT ALL ON opendental.rxalert TO 'user'@'127.0.0.1';
  654. GRANT ALL ON opendental.rxdef TO 'user'@'127.0.0.1';
  655. GRANT ALL ON opendental.rxnorm TO 'user'@'127.0.0.1';
  656. GRANT ALL ON opendental.rxpat TO 'user'@'127.0.0.1';
  657. GRANT ALL ON opendental.schedule TO 'user'@'127.0.0.1';
  658. GRANT ALL ON opendental.scheduleop TO 'user'@'127.0.0.1';
  659. GRANT ALL ON opendental.schoolclass TO 'user'@'127.0.0.1';
  660. GRANT ALL ON opendental.schoolcourse TO 'user'@'127.0.0.1';
  661. GRANT ALL ON opendental.screen TO 'user'@'127.0.0.1';
  662. GRANT ALL ON opendental.screengroup TO 'user'@'127.0.0.1';
  663. GRANT ALL ON opendental.screenpat TO 'user'@'127.0.0.1';
  664. GRANT ALL ON opendental.securitylog TO 'user'@'127.0.0.1';
  665. GRANT ALL ON opendental.securityloghash TO 'user'@'127.0.0.1';
  666. GRANT ALL ON opendental.sheet TO 'user'@'127.0.0.1';
  667. GRANT ALL ON opendental.sheetdef TO 'user'@'127.0.0.1';
  668. GRANT ALL ON opendental.sheetfield TO 'user'@'127.0.0.1';
  669. GRANT ALL ON opendental.sheetfielddef TO 'user'@'127.0.0.1';
  670. GRANT ALL ON opendental.sigbutdef TO 'user'@'127.0.0.1';
  671. GRANT ALL ON opendental.sigelementdef TO 'user'@'127.0.0.1';
  672. GRANT ALL ON opendental.sigmessage TO 'user'@'127.0.0.1';
  673. GRANT ALL ON opendental.signalod TO 'user'@'127.0.0.1';
  674. GRANT ALL ON opendental.site TO 'user'@'127.0.0.1';
  675. GRANT ALL ON opendental.smsblockphone TO 'user'@'127.0.0.1';
  676. GRANT ALL ON opendental.smsfrommobile TO 'user'@'127.0.0.1';
  677. GRANT ALL ON opendental.smsphone TO 'user'@'127.0.0.1';
  678. GRANT ALL ON opendental.smstomobile TO 'user'@'127.0.0.1';
  679. GRANT ALL ON opendental.snomed TO 'user'@'127.0.0.1';
  680. GRANT ALL ON opendental.sop TO 'user'@'127.0.0.1';
  681. GRANT ALL ON opendental.stateabbr TO 'user'@'127.0.0.1';
  682. GRANT ALL ON opendental.statement TO 'user'@'127.0.0.1';
  683. GRANT ALL ON opendental.stmtlink TO 'user'@'127.0.0.1';
  684. GRANT ALL ON opendental.substitutionlink TO 'user'@'127.0.0.1';
  685. GRANT ALL ON opendental.supplier TO 'user'@'127.0.0.1';
  686. GRANT ALL ON opendental.supply TO 'user'@'127.0.0.1';
  687. GRANT ALL ON opendental.supplyneeded TO 'user'@'127.0.0.1';
  688. GRANT ALL ON opendental.supplyorder TO 'user'@'127.0.0.1';
  689. GRANT ALL ON opendental.supplyorderitem TO 'user'@'127.0.0.1';
  690. GRANT ALL ON opendental.task TO 'user'@'127.0.0.1';
  691. GRANT ALL ON opendental.taskancestor TO 'user'@'127.0.0.1';
  692. GRANT ALL ON opendental.taskhist TO 'user'@'127.0.0.1';
  693. GRANT ALL ON opendental.tasklist TO 'user'@'127.0.0.1';
  694. GRANT ALL ON opendental.tasknote TO 'user'@'127.0.0.1';
  695. GRANT ALL ON opendental.tasksubscription TO 'user'@'127.0.0.1';
  696. GRANT ALL ON opendental.taskunread TO 'user'@'127.0.0.1';
  697. GRANT ALL ON opendental.terminalactive TO 'user'@'127.0.0.1';
  698. GRANT ALL ON opendental.timeadjust TO 'user'@'127.0.0.1';
  699. GRANT ALL ON opendental.timecardrule TO 'user'@'127.0.0.1';
  700. GRANT ALL ON opendental.toolbutitem TO 'user'@'127.0.0.1';
  701. GRANT ALL ON opendental.toothgridcell TO 'user'@'127.0.0.1';
  702. GRANT ALL ON opendental.toothgridcol TO 'user'@'127.0.0.1';
  703. GRANT ALL ON opendental.toothgriddef TO 'user'@'127.0.0.1';
  704. GRANT ALL ON opendental.toothinitial TO 'user'@'127.0.0.1';
  705. GRANT ALL ON opendental.transaction TO 'user'@'127.0.0.1';
  706. GRANT ALL ON opendental.treatplan TO 'user'@'127.0.0.1';
  707. GRANT ALL ON opendental.treatplanattach TO 'user'@'127.0.0.1';
  708. GRANT ALL ON opendental.tsitranslog TO 'user'@'127.0.0.1';
  709. GRANT ALL ON opendental.ucum TO 'user'@'127.0.0.1';
  710. GRANT ALL ON opendental.updatehistory TO 'user'@'127.0.0.1';
  711. GRANT ALL ON opendental.userclinic TO 'user'@'127.0.0.1';
  712. GRANT ALL ON opendental.usergroup TO 'user'@'127.0.0.1';
  713. GRANT ALL ON opendental.usergroupattach TO 'user'@'127.0.0.1';
  714. GRANT ALL ON opendental.userod TO 'user'@'127.0.0.1';
  715. GRANT ALL ON opendental.userodapptview TO 'user'@'127.0.0.1';
  716. GRANT ALL ON opendental.userodpref TO 'user'@'127.0.0.1';
  717. GRANT ALL ON opendental.userquery TO 'user'@'127.0.0.1';
  718. GRANT ALL ON opendental.userweb TO 'user'@'127.0.0.1';
  719. GRANT ALL ON opendental.vaccinedef TO 'user'@'127.0.0.1';
  720. GRANT ALL ON opendental.vaccineobs TO 'user'@'127.0.0.1';
  721. GRANT ALL ON opendental.vaccinepat TO 'user'@'127.0.0.1';
  722. GRANT ALL ON opendental.vitalsign TO 'user'@'127.0.0.1';
  723. GRANT ALL ON opendental.webschedrecall TO 'user'@'127.0.0.1';
  724. GRANT ALL ON opendental.wikilistheaderwidth TO 'user'@'127.0.0.1';
  725. GRANT ALL ON opendental.wikilisthist TO 'user'@'127.0.0.1';
  726. GRANT ALL ON opendental.wikipage TO 'user'@'127.0.0.1';
  727. GRANT ALL ON opendental.wikipagehist TO 'user'@'127.0.0.1';
  728. GRANT ALL ON opendental.xchargetransaction TO 'user'@'127.0.0.1';
  729. GRANT ALL ON opendental.xwebresponse TO 'user'@'127.0.0.1';
  730. GRANT ALL ON opendental.zipcode TO 'user'@'127.0.0.1';
  731. GRANT SELECT, SELECT (RepeatChargeNum, ProvNum, DateTP, ProcNum, ClaimNote, AptNum, DiagnosticCode, DateOriginalProsth, OrderingReferralNum, ProcTimeEnd, BaseUnits, Prosthesis, CanadianTypeCodes, Surf, StatementNum, ProcStatus, DrugUnit, IcdVersion, ToothRange, ToothNum, ProvOrderOverride, BillingTypeTwo, PlaceService, SnomedBodySite, IsLocked, ProcTime, DateComplete, Priority, TaxAmt, IsCpoe, DiagnosticCode4, OldCode, ProcNumLab, ClinicNum, ProcDate, CodeMod3, StartTime, CodeNum, Discount, SiteNum, StopTime, MedicalCode, PatNum, UnitQty, IsPrincDiag, Prognosis, IsDateProsthEst, CodeMod2, BillingNote, UnitQtyType, CodeMod1, DateEntryC, RevCode, DateTStamp, CodeMod4, PlannedAptNum, SecUserNumEntry, BillingTypeOne, SecDateEntry, HideGraphics, DiagnosticCode3, Dx, DiagnosticCode2, DrugQty, ProcFee), INSERT, UPDATE (RepeatChargeNum, ProvNum, DateTP, ProcNum, ClaimNote, AptNum, DiagnosticCode, DateOriginalProsth, OrderingReferralNum, ProcTimeEnd, BaseUnits, Prosthesis, CanadianTypeCodes, Surf, StatementNum, ProcStatus, DrugUnit, IcdVersion, ToothRange, ToothNum, ProvOrderOverride, BillingTypeTwo, PlaceService, SnomedBodySite, IsLocked, ProcTime, DateComplete, Priority, TaxAmt, IsCpoe, DiagnosticCode4, OldCode, ProcNumLab, ClinicNum, ProcDate, CodeMod3, StartTime, CodeNum, Discount, SiteNum, StopTime, MedicalCode, PatNum, UnitQty, IsPrincDiag, Prognosis, IsDateProsthEst, CodeMod2, BillingNote, UnitQtyType, CodeMod1, DateEntryC, RevCode, CodeMod4, PlannedAptNum, SecUserNumEntry, BillingTypeOne, SecDateEntry, HideGraphics, DiagnosticCode3, Dx, DiagnosticCode2, DrugQty, ProcFee), DELETE, SHOW VIEW ON `opendental`.`procedurelog` TO 'user'@'127.0.0.1';
  732.  
  733. GRANT ALL ON opendental.account TO 'user'@'localhost';
  734. GRANT ALL ON opendental.accountingautopay TO 'user'@'localhost';
  735. GRANT ALL ON opendental.adjustment TO 'user'@'localhost';
  736. GRANT ALL ON opendental.alertcategory TO 'user'@'localhost';
  737. GRANT ALL ON opendental.alertcategorylink TO 'user'@'localhost';
  738. GRANT ALL ON opendental.alertitem TO 'user'@'localhost';
  739. GRANT ALL ON opendental.alertread TO 'user'@'localhost';
  740. GRANT ALL ON opendental.alertsub TO 'user'@'localhost';
  741. GRANT ALL ON opendental.allergy TO 'user'@'localhost';
  742. GRANT ALL ON opendental.allergydef TO 'user'@'localhost';
  743. GRANT ALL ON opendental.anestheticdata TO 'user'@'localhost';
  744. GRANT ALL ON opendental.anestheticrecord TO 'user'@'localhost';
  745. GRANT ALL ON opendental.anesthmedsgiven TO 'user'@'localhost';
  746. GRANT ALL ON opendental.anesthmedsintake TO 'user'@'localhost';
  747. GRANT ALL ON opendental.anesthmedsinventory TO 'user'@'localhost';
  748. GRANT ALL ON opendental.anesthmedsinventoryadj TO 'user'@'localhost';
  749. GRANT ALL ON opendental.anesthmedsuppliers TO 'user'@'localhost';
  750. GRANT ALL ON opendental.anesthscore TO 'user'@'localhost';
  751. GRANT ALL ON opendental.anesthvsdata TO 'user'@'localhost';
  752. GRANT ALL ON opendental.appointment TO 'user'@'localhost';
  753. GRANT ALL ON opendental.appointmentrule TO 'user'@'localhost';
  754. GRANT ALL ON opendental.appointmenttype TO 'user'@'localhost';
  755. GRANT ALL ON opendental.apptfield TO 'user'@'localhost';
  756. GRANT ALL ON opendental.apptfielddef TO 'user'@'localhost';
  757. GRANT ALL ON opendental.apptreminderrule TO 'user'@'localhost';
  758. GRANT ALL ON opendental.apptremindersent TO 'user'@'localhost';
  759. GRANT ALL ON opendental.apptview TO 'user'@'localhost';
  760. GRANT ALL ON opendental.apptviewitem TO 'user'@'localhost';
  761. GRANT ALL ON opendental.asapcomm TO 'user'@'localhost';
  762. GRANT ALL ON opendental.autocode TO 'user'@'localhost';
  763. GRANT ALL ON opendental.autocodecond TO 'user'@'localhost';
  764. GRANT ALL ON opendental.autocodeitem TO 'user'@'localhost';
  765. GRANT ALL ON opendental.automation TO 'user'@'localhost';
  766. GRANT ALL ON opendental.automationcondition TO 'user'@'localhost';
  767. GRANT ALL ON opendental.autonote TO 'user'@'localhost';
  768. GRANT ALL ON opendental.autonotecontrol TO 'user'@'localhost';
  769. GRANT ALL ON opendental.benefit TO 'user'@'localhost';
  770. GRANT ALL ON opendental.canadiannetwork TO 'user'@'localhost';
  771. GRANT ALL ON opendental.carrier TO 'user'@'localhost';
  772. GRANT ALL ON opendental.cdcrec TO 'user'@'localhost';
  773. GRANT ALL ON opendental.cdspermission TO 'user'@'localhost';
  774. GRANT ALL ON opendental.centralconnection TO 'user'@'localhost';
  775. GRANT ALL ON opendental.chartview TO 'user'@'localhost';
  776. GRANT ALL ON opendental.claim TO 'user'@'localhost';
  777. GRANT ALL ON opendental.claimattach TO 'user'@'localhost';
  778. GRANT ALL ON opendental.claimcondcodelog TO 'user'@'localhost';
  779. GRANT ALL ON opendental.claimform TO 'user'@'localhost';
  780. GRANT ALL ON opendental.claimformitem TO 'user'@'localhost';
  781. GRANT ALL ON opendental.claimpayment TO 'user'@'localhost';
  782. GRANT ALL ON opendental.claimproc TO 'user'@'localhost';
  783. GRANT ALL ON opendental.claimsnapshot TO 'user'@'localhost';
  784. GRANT ALL ON opendental.claimtracking TO 'user'@'localhost';
  785. GRANT ALL ON opendental.claimvalcodelog TO 'user'@'localhost';
  786. GRANT ALL ON opendental.clearinghouse TO 'user'@'localhost';
  787. GRANT ALL ON opendental.clinic TO 'user'@'localhost';
  788. GRANT ALL ON opendental.clinicerx TO 'user'@'localhost';
  789. GRANT ALL ON opendental.clinicpref TO 'user'@'localhost';
  790. GRANT ALL ON opendental.clockevent TO 'user'@'localhost';
  791. GRANT ALL ON opendental.codesystem TO 'user'@'localhost';
  792. GRANT ALL ON opendental.commlog TO 'user'@'localhost';
  793. GRANT ALL ON opendental.commoptout TO 'user'@'localhost';
  794. GRANT ALL ON opendental.computer TO 'user'@'localhost';
  795. GRANT ALL ON opendental.computerpref TO 'user'@'localhost';
  796. GRANT ALL ON opendental.confirmationrequest TO 'user'@'localhost';
  797. GRANT ALL ON opendental.connectiongroup TO 'user'@'localhost';
  798. GRANT ALL ON opendental.conngroupattach TO 'user'@'localhost';
  799. GRANT ALL ON opendental.contact TO 'user'@'localhost';
  800. GRANT ALL ON opendental.county TO 'user'@'localhost';
  801. GRANT ALL ON opendental.covcat TO 'user'@'localhost';
  802. GRANT ALL ON opendental.covspan TO 'user'@'localhost';
  803. GRANT ALL ON opendental.cpt TO 'user'@'localhost';
  804. GRANT ALL ON opendental.creditcard TO 'user'@'localhost';
  805. GRANT ALL ON opendental.custrefentry TO 'user'@'localhost';
  806. GRANT ALL ON opendental.custreference TO 'user'@'localhost';
  807. GRANT ALL ON opendental.cvx TO 'user'@'localhost';
  808. GRANT ALL ON opendental.dashboardar TO 'user'@'localhost';
  809. GRANT ALL ON opendental.dashboardcell TO 'user'@'localhost';
  810. GRANT ALL ON opendental.dashboardlayout TO 'user'@'localhost';
  811. GRANT ALL ON opendental.databasemaintenance TO 'user'@'localhost';
  812. GRANT ALL ON opendental.dbmlog TO 'user'@'localhost';
  813. GRANT ALL ON opendental.definition TO 'user'@'localhost';
  814. GRANT ALL ON opendental.deflink TO 'user'@'localhost';
  815. GRANT ALL ON opendental.deletedobject TO 'user'@'localhost';
  816. GRANT ALL ON opendental.deposit TO 'user'@'localhost';
  817. GRANT ALL ON opendental.dictcustom TO 'user'@'localhost';
  818. GRANT ALL ON opendental.discountplan TO 'user'@'localhost';
  819. GRANT ALL ON opendental.disease TO 'user'@'localhost';
  820. GRANT ALL ON opendental.diseasedef TO 'user'@'localhost';
  821. GRANT ALL ON opendental.displayfield TO 'user'@'localhost';
  822. GRANT ALL ON opendental.displayreport TO 'user'@'localhost';
  823. GRANT ALL ON opendental.dispsupply TO 'user'@'localhost';
  824. GRANT ALL ON opendental.document TO 'user'@'localhost';
  825. GRANT ALL ON opendental.documentmisc TO 'user'@'localhost';
  826. GRANT ALL ON opendental.drugmanufacturer TO 'user'@'localhost';
  827. GRANT ALL ON opendental.drugunit TO 'user'@'localhost';
  828. GRANT ALL ON opendental.dunning TO 'user'@'localhost';
  829. GRANT ALL ON opendental.ebill TO 'user'@'localhost';
  830. GRANT ALL ON opendental.eduresource TO 'user'@'localhost';
  831. GRANT ALL ON opendental.ehramendment TO 'user'@'localhost';
  832. GRANT ALL ON opendental.ehraptobs TO 'user'@'localhost';
  833. GRANT ALL ON opendental.ehrcareplan TO 'user'@'localhost';
  834. GRANT ALL ON opendental.ehrlab TO 'user'@'localhost';
  835. GRANT ALL ON opendental.ehrlabclinicalinfo TO 'user'@'localhost';
  836. GRANT ALL ON opendental.ehrlabimage TO 'user'@'localhost';
  837. GRANT ALL ON opendental.ehrlabnote TO 'user'@'localhost';
  838. GRANT ALL ON opendental.ehrlabresult TO 'user'@'localhost';
  839. GRANT ALL ON opendental.ehrlabresultscopyto TO 'user'@'localhost';
  840. GRANT ALL ON opendental.ehrlabspecimen TO 'user'@'localhost';
  841. GRANT ALL ON opendental.ehrlabspecimencondition TO 'user'@'localhost';
  842. GRANT ALL ON opendental.ehrlabspecimenrejectreason TO 'user'@'localhost';
  843. GRANT ALL ON opendental.ehrmeasure TO 'user'@'localhost';
  844. GRANT ALL ON opendental.ehrmeasureevent TO 'user'@'localhost';
  845. GRANT ALL ON opendental.ehrnotperformed TO 'user'@'localhost';
  846. GRANT ALL ON opendental.ehrpatient TO 'user'@'localhost';
  847. GRANT ALL ON opendental.ehrprovkey TO 'user'@'localhost';
  848. GRANT ALL ON opendental.ehrquarterlykey TO 'user'@'localhost';
  849. GRANT ALL ON opendental.ehrsummaryccd TO 'user'@'localhost';
  850. GRANT ALL ON opendental.ehrtrigger TO 'user'@'localhost';
  851. GRANT ALL ON opendental.electid TO 'user'@'localhost';
  852. GRANT ALL ON opendental.emailaddress TO 'user'@'localhost';
  853. GRANT ALL ON opendental.emailattach TO 'user'@'localhost';
  854. GRANT ALL ON opendental.emailautograph TO 'user'@'localhost';
  855. GRANT ALL ON opendental.emailmessage TO 'user'@'localhost';
  856. GRANT ALL ON opendental.emailmessageuid TO 'user'@'localhost';
  857. GRANT ALL ON opendental.emailtemplate TO 'user'@'localhost';
  858. GRANT ALL ON opendental.employee TO 'user'@'localhost';
  859. GRANT ALL ON opendental.employer TO 'user'@'localhost';
  860. GRANT ALL ON opendental.encounter TO 'user'@'localhost';
  861. GRANT ALL ON opendental.entrylog TO 'user'@'localhost';
  862. GRANT ALL ON opendental.eobattach TO 'user'@'localhost';
  863. GRANT ALL ON opendental.equipment TO 'user'@'localhost';
  864. GRANT ALL ON opendental.erxlog TO 'user'@'localhost';
  865. GRANT ALL ON opendental.eservicesignal TO 'user'@'localhost';
  866. GRANT ALL ON opendental.etrans TO 'user'@'localhost';
  867. GRANT ALL ON opendental.etrans835attach TO 'user'@'localhost';
  868. GRANT ALL ON opendental.etransmessagetext TO 'user'@'localhost';
  869. GRANT ALL ON opendental.evaluation TO 'user'@'localhost';
  870. GRANT ALL ON opendental.evaluationcriterion TO 'user'@'localhost';
  871. GRANT ALL ON opendental.evaluationcriteriondef TO 'user'@'localhost';
  872. GRANT ALL ON opendental.evaluationdef TO 'user'@'localhost';
  873. GRANT ALL ON opendental.famaging TO 'user'@'localhost';
  874. GRANT ALL ON opendental.familyhealth TO 'user'@'localhost';
  875. GRANT ALL ON opendental.fee TO 'user'@'localhost';
  876. GRANT ALL ON opendental.feesched TO 'user'@'localhost';
  877. GRANT ALL ON opendental.fhircontactpoint TO 'user'@'localhost';
  878. GRANT ALL ON opendental.fhirsubscription TO 'user'@'localhost';
  879. GRANT ALL ON opendental.fielddeflink TO 'user'@'localhost';
  880. GRANT ALL ON opendental.files TO 'user'@'localhost';
  881. GRANT ALL ON opendental.formpat TO 'user'@'localhost';
  882. GRANT ALL ON opendental.gradingscale TO 'user'@'localhost';
  883. GRANT ALL ON opendental.gradingscaleitem TO 'user'@'localhost';
  884. GRANT ALL ON opendental.grouppermission TO 'user'@'localhost';
  885. GRANT ALL ON opendental.guardian TO 'user'@'localhost';
  886. GRANT ALL ON opendental.hcpcs TO 'user'@'localhost';
  887. GRANT ALL ON opendental.histappointment TO 'user'@'localhost';
  888. GRANT ALL ON opendental.hl7def TO 'user'@'localhost';
  889. GRANT ALL ON opendental.hl7deffield TO 'user'@'localhost';
  890. GRANT ALL ON opendental.hl7defmessage TO 'user'@'localhost';
  891. GRANT ALL ON opendental.hl7defsegment TO 'user'@'localhost';
  892. GRANT ALL ON opendental.hl7msg TO 'user'@'localhost';
  893. GRANT ALL ON opendental.hl7procattach TO 'user'@'localhost';
  894. GRANT ALL ON opendental.icd10 TO 'user'@'localhost';
  895. GRANT ALL ON opendental.icd9 TO 'user'@'localhost';
  896. GRANT ALL ON opendental.inseditlog TO 'user'@'localhost';
  897. GRANT ALL ON opendental.insfilingcode TO 'user'@'localhost';
  898. GRANT ALL ON opendental.insfilingcodesubtype TO 'user'@'localhost';
  899. GRANT ALL ON opendental.insplan TO 'user'@'localhost';
  900. GRANT ALL ON opendental.inssub TO 'user'@'localhost';
  901. GRANT ALL ON opendental.installmentplan TO 'user'@'localhost';
  902. GRANT ALL ON opendental.instructor TO 'user'@'localhost';
  903. GRANT ALL ON opendental.insverify TO 'user'@'localhost';
  904. GRANT ALL ON opendental.insverifyhist TO 'user'@'localhost';
  905. GRANT ALL ON opendental.intervention TO 'user'@'localhost';
  906. GRANT ALL ON opendental.journalentry TO 'user'@'localhost';
  907. GRANT ALL ON opendental.labcase TO 'user'@'localhost';
  908. GRANT ALL ON opendental.laboratory TO 'user'@'localhost';
  909. GRANT ALL ON opendental.labpanel TO 'user'@'localhost';
  910. GRANT ALL ON opendental.labresult TO 'user'@'localhost';
  911. GRANT ALL ON opendental.labturnaround TO 'user'@'localhost';
  912. GRANT ALL ON opendental.language TO 'user'@'localhost';
  913. GRANT ALL ON opendental.languageforeign TO 'user'@'localhost';
  914. GRANT ALL ON opendental.letter TO 'user'@'localhost';
  915. GRANT ALL ON opendental.lettermerge TO 'user'@'localhost';
  916. GRANT ALL ON opendental.lettermergefield TO 'user'@'localhost';
  917. GRANT ALL ON opendental.loinc TO 'user'@'localhost';
  918. GRANT ALL ON opendental.maparea TO 'user'@'localhost';
  919. GRANT ALL ON opendental.medicalorder TO 'user'@'localhost';
  920. GRANT ALL ON opendental.medication TO 'user'@'localhost';
  921. GRANT ALL ON opendental.medicationpat TO 'user'@'localhost';
  922. GRANT ALL ON opendental.medlab TO 'user'@'localhost';
  923. GRANT ALL ON opendental.medlabfacattach TO 'user'@'localhost';
  924. GRANT ALL ON opendental.medlabfacility TO 'user'@'localhost';
  925. GRANT ALL ON opendental.medlabresult TO 'user'@'localhost';
  926. GRANT ALL ON opendental.medlabspecimen TO 'user'@'localhost';
  927. GRANT ALL ON opendental.mobileappdevice TO 'user'@'localhost';
  928. GRANT ALL ON opendental.mount TO 'user'@'localhost';
  929. GRANT ALL ON opendental.mountdef TO 'user'@'localhost';
  930. GRANT ALL ON opendental.mountitem TO 'user'@'localhost';
  931. GRANT ALL ON opendental.mountitemdef TO 'user'@'localhost';
  932. GRANT ALL ON opendental.oidexternal TO 'user'@'localhost';
  933. GRANT ALL ON opendental.oidinternal TO 'user'@'localhost';
  934. GRANT ALL ON opendental.operatory TO 'user'@'localhost';
  935. GRANT ALL ON opendental.orionproc TO 'user'@'localhost';
  936. GRANT ALL ON opendental.orthochart TO 'user'@'localhost';
  937. GRANT ALL ON opendental.orthocharttab TO 'user'@'localhost';
  938. GRANT ALL ON opendental.orthocharttablink TO 'user'@'localhost';
  939. GRANT ALL ON opendental.patfield TO 'user'@'localhost';
  940. GRANT ALL ON opendental.patfielddef TO 'user'@'localhost';
  941. GRANT ALL ON opendental.patient TO 'user'@'localhost';
  942. GRANT ALL ON opendental.patientlink TO 'user'@'localhost';
  943. GRANT ALL ON opendental.patientnote TO 'user'@'localhost';
  944. GRANT ALL ON opendental.patientportalinvite TO 'user'@'localhost';
  945. GRANT ALL ON opendental.patientrace TO 'user'@'localhost';
  946. GRANT ALL ON opendental.patplan TO 'user'@'localhost';
  947. GRANT ALL ON opendental.patrestriction TO 'user'@'localhost';
  948. GRANT ALL ON opendental.payconnectresponseweb TO 'user'@'localhost';
  949. GRANT ALL ON opendental.payment TO 'user'@'localhost';
  950. GRANT ALL ON opendental.payortype TO 'user'@'localhost';
  951. GRANT ALL ON opendental.payperiod TO 'user'@'localhost';
  952. GRANT ALL ON opendental.payplan TO 'user'@'localhost';
  953. GRANT ALL ON opendental.payplancharge TO 'user'@'localhost';
  954. GRANT ALL ON opendental.paysplit TO 'user'@'localhost';
  955. GRANT ALL ON opendental.perioexam TO 'user'@'localhost';
  956. GRANT ALL ON opendental.periomeasure TO 'user'@'localhost';
  957. GRANT ALL ON opendental.pharmacy TO 'user'@'localhost';
  958. GRANT ALL ON opendental.pharmclinic TO 'user'@'localhost';
  959. GRANT ALL ON opendental.phonenumber TO 'user'@'localhost';
  960. GRANT ALL ON opendental.plannedappt TO 'user'@'localhost';
  961. GRANT ALL ON opendental.popup TO 'user'@'localhost';
  962. GRANT ALL ON opendental.preference TO 'user'@'localhost';
  963. GRANT ALL ON opendental.printer TO 'user'@'localhost';
  964. GRANT ALL ON opendental.procapptcolor TO 'user'@'localhost';
  965. GRANT ALL ON opendental.procbutton TO 'user'@'localhost';
  966. GRANT ALL ON opendental.procbuttonitem TO 'user'@'localhost';
  967. GRANT ALL ON opendental.procbuttonquick TO 'user'@'localhost';
  968. GRANT ALL ON opendental.proccodenote TO 'user'@'localhost';
  969. GRANT ALL ON opendental.procedurecode TO 'user'@'localhost';
  970. GRANT ALL ON opendental.procgroupitem TO 'user'@'localhost';
  971. GRANT ALL ON opendental.procmultivisit TO 'user'@'localhost';
  972. GRANT ALL ON opendental.procnote TO 'user'@'localhost';
  973. GRANT ALL ON opendental.proctp TO 'user'@'localhost';
  974. GRANT ALL ON opendental.program TO 'user'@'localhost';
  975. GRANT ALL ON opendental.programproperty TO 'user'@'localhost';
  976. GRANT ALL ON opendental.provider TO 'user'@'localhost';
  977. GRANT ALL ON opendental.providerclinic TO 'user'@'localhost';
  978. GRANT ALL ON opendental.providercliniclink TO 'user'@'localhost';
  979. GRANT ALL ON opendental.providererx TO 'user'@'localhost';
  980. GRANT ALL ON opendental.providerident TO 'user'@'localhost';
  981. GRANT ALL ON opendental.question TO 'user'@'localhost';
  982. GRANT ALL ON opendental.questiondef TO 'user'@'localhost';
  983. GRANT ALL ON opendental.quickpastecat TO 'user'@'localhost';
  984. GRANT ALL ON opendental.quickpastenote TO 'user'@'localhost';
  985. GRANT ALL ON opendental.reactivation TO 'user'@'localhost';
  986. GRANT ALL ON opendental.recall TO 'user'@'localhost';
  987. GRANT ALL ON opendental.recalltrigger TO 'user'@'localhost';
  988. GRANT ALL ON opendental.recalltype TO 'user'@'localhost';
  989. GRANT ALL ON opendental.reconcile TO 'user'@'localhost';
  990. GRANT ALL ON opendental.recurringcharge TO 'user'@'localhost';
  991. GRANT ALL ON opendental.refattach TO 'user'@'localhost';
  992. GRANT ALL ON opendental.referral TO 'user'@'localhost';
  993. GRANT ALL ON opendental.registrationkey TO 'user'@'localhost';
  994. GRANT ALL ON opendental.reminderrule TO 'user'@'localhost';
  995. GRANT ALL ON opendental.repeatcharge TO 'user'@'localhost';
  996. GRANT ALL ON opendental.replicationserver TO 'user'@'localhost';
  997. GRANT ALL ON opendental.reqneeded TO 'user'@'localhost';
  998. GRANT ALL ON opendental.reqstudent TO 'user'@'localhost';
  999. GRANT ALL ON opendental.requiredfield TO 'user'@'localhost';
  1000. GRANT ALL ON opendental.requiredfieldcondition TO 'user'@'localhost';
  1001. GRANT ALL ON opendental.reseller TO 'user'@'localhost';
  1002. GRANT ALL ON opendental.resellerservice TO 'user'@'localhost';
  1003. GRANT ALL ON opendental.rxalert TO 'user'@'localhost';
  1004. GRANT ALL ON opendental.rxdef TO 'user'@'localhost';
  1005. GRANT ALL ON opendental.rxnorm TO 'user'@'localhost';
  1006. GRANT ALL ON opendental.rxpat TO 'user'@'localhost';
  1007. GRANT ALL ON opendental.schedule TO 'user'@'localhost';
  1008. GRANT ALL ON opendental.scheduleop TO 'user'@'localhost';
  1009. GRANT ALL ON opendental.schoolclass TO 'user'@'localhost';
  1010. GRANT ALL ON opendental.schoolcourse TO 'user'@'localhost';
  1011. GRANT ALL ON opendental.screen TO 'user'@'localhost';
  1012. GRANT ALL ON opendental.screengroup TO 'user'@'localhost';
  1013. GRANT ALL ON opendental.screenpat TO 'user'@'localhost';
  1014. GRANT ALL ON opendental.securitylog TO 'user'@'localhost';
  1015. GRANT ALL ON opendental.securityloghash TO 'user'@'localhost';
  1016. GRANT ALL ON opendental.sheet TO 'user'@'localhost';
  1017. GRANT ALL ON opendental.sheetdef TO 'user'@'localhost';
  1018. GRANT ALL ON opendental.sheetfield TO 'user'@'localhost';
  1019. GRANT ALL ON opendental.sheetfielddef TO 'user'@'localhost';
  1020. GRANT ALL ON opendental.sigbutdef TO 'user'@'localhost';
  1021. GRANT ALL ON opendental.sigelementdef TO 'user'@'localhost';
  1022. GRANT ALL ON opendental.sigmessage TO 'user'@'localhost';
  1023. GRANT ALL ON opendental.signalod TO 'user'@'localhost';
  1024. GRANT ALL ON opendental.site TO 'user'@'localhost';
  1025. GRANT ALL ON opendental.smsblockphone TO 'user'@'localhost';
  1026. GRANT ALL ON opendental.smsfrommobile TO 'user'@'localhost';
  1027. GRANT ALL ON opendental.smsphone TO 'user'@'localhost';
  1028. GRANT ALL ON opendental.smstomobile TO 'user'@'localhost';
  1029. GRANT ALL ON opendental.snomed TO 'user'@'localhost';
  1030. GRANT ALL ON opendental.sop TO 'user'@'localhost';
  1031. GRANT ALL ON opendental.stateabbr TO 'user'@'localhost';
  1032. GRANT ALL ON opendental.statement TO 'user'@'localhost';
  1033. GRANT ALL ON opendental.stmtlink TO 'user'@'localhost';
  1034. GRANT ALL ON opendental.substitutionlink TO 'user'@'localhost';
  1035. GRANT ALL ON opendental.supplier TO 'user'@'localhost';
  1036. GRANT ALL ON opendental.supply TO 'user'@'localhost';
  1037. GRANT ALL ON opendental.supplyneeded TO 'user'@'localhost';
  1038. GRANT ALL ON opendental.supplyorder TO 'user'@'localhost';
  1039. GRANT ALL ON opendental.supplyorderitem TO 'user'@'localhost';
  1040. GRANT ALL ON opendental.task TO 'user'@'localhost';
  1041. GRANT ALL ON opendental.taskancestor TO 'user'@'localhost';
  1042. GRANT ALL ON opendental.taskhist TO 'user'@'localhost';
  1043. GRANT ALL ON opendental.tasklist TO 'user'@'localhost';
  1044. GRANT ALL ON opendental.tasknote TO 'user'@'localhost';
  1045. GRANT ALL ON opendental.tasksubscription TO 'user'@'localhost';
  1046. GRANT ALL ON opendental.taskunread TO 'user'@'localhost';
  1047. GRANT ALL ON opendental.terminalactive TO 'user'@'localhost';
  1048. GRANT ALL ON opendental.timeadjust TO 'user'@'localhost';
  1049. GRANT ALL ON opendental.timecardrule TO 'user'@'localhost';
  1050. GRANT ALL ON opendental.toolbutitem TO 'user'@'localhost';
  1051. GRANT ALL ON opendental.toothgridcell TO 'user'@'localhost';
  1052. GRANT ALL ON opendental.toothgridcol TO 'user'@'localhost';
  1053. GRANT ALL ON opendental.toothgriddef TO 'user'@'localhost';
  1054. GRANT ALL ON opendental.toothinitial TO 'user'@'localhost';
  1055. GRANT ALL ON opendental.transaction TO 'user'@'localhost';
  1056. GRANT ALL ON opendental.treatplan TO 'user'@'localhost';
  1057. GRANT ALL ON opendental.treatplanattach TO 'user'@'localhost';
  1058. GRANT ALL ON opendental.tsitranslog TO 'user'@'localhost';
  1059. GRANT ALL ON opendental.ucum TO 'user'@'localhost';
  1060. GRANT ALL ON opendental.updatehistory TO 'user'@'localhost';
  1061. GRANT ALL ON opendental.userclinic TO 'user'@'localhost';
  1062. GRANT ALL ON opendental.usergroup TO 'user'@'localhost';
  1063. GRANT ALL ON opendental.usergroupattach TO 'user'@'localhost';
  1064. GRANT ALL ON opendental.userod TO 'user'@'localhost';
  1065. GRANT ALL ON opendental.userodapptview TO 'user'@'localhost';
  1066. GRANT ALL ON opendental.userodpref TO 'user'@'localhost';
  1067. GRANT ALL ON opendental.userquery TO 'user'@'localhost';
  1068. GRANT ALL ON opendental.userweb TO 'user'@'localhost';
  1069. GRANT ALL ON opendental.vaccinedef TO 'user'@'localhost';
  1070. GRANT ALL ON opendental.vaccineobs TO 'user'@'localhost';
  1071. GRANT ALL ON opendental.vaccinepat TO 'user'@'localhost';
  1072. GRANT ALL ON opendental.vitalsign TO 'user'@'localhost';
  1073. GRANT ALL ON opendental.webschedrecall TO 'user'@'localhost';
  1074. GRANT ALL ON opendental.wikilistheaderwidth TO 'user'@'localhost';
  1075. GRANT ALL ON opendental.wikilisthist TO 'user'@'localhost';
  1076. GRANT ALL ON opendental.wikipage TO 'user'@'localhost';
  1077. GRANT ALL ON opendental.wikipagehist TO 'user'@'localhost';
  1078. GRANT ALL ON opendental.xchargetransaction TO 'user'@'localhost';
  1079. GRANT ALL ON opendental.xwebresponse TO 'user'@'localhost';
  1080. GRANT ALL ON opendental.zipcode TO 'user'@'localhost';
  1081. GRANT SELECT, SELECT (RepeatChargeNum, ProvNum, DateTP, ProcNum, ClaimNote, AptNum, DiagnosticCode, DateOriginalProsth, OrderingReferralNum, ProcTimeEnd, BaseUnits, Prosthesis, CanadianTypeCodes, Surf, StatementNum, ProcStatus, DrugUnit, IcdVersion, ToothRange, ToothNum, ProvOrderOverride, BillingTypeTwo, PlaceService, SnomedBodySite, IsLocked, ProcTime, DateComplete, Priority, TaxAmt, IsCpoe, DiagnosticCode4, OldCode, ProcNumLab, ClinicNum, ProcDate, CodeMod3, StartTime, CodeNum, Discount, SiteNum, StopTime, MedicalCode, PatNum, UnitQty, IsPrincDiag, Prognosis, IsDateProsthEst, CodeMod2, BillingNote, UnitQtyType, CodeMod1, DateEntryC, RevCode, DateTStamp, CodeMod4, PlannedAptNum, SecUserNumEntry, BillingTypeOne, SecDateEntry, HideGraphics, DiagnosticCode3, Dx, DiagnosticCode2, DrugQty, ProcFee), INSERT, UPDATE (RepeatChargeNum, ProvNum, DateTP, ProcNum, ClaimNote, AptNum, DiagnosticCode, DateOriginalProsth, OrderingReferralNum, ProcTimeEnd, BaseUnits, Prosthesis, CanadianTypeCodes, Surf, StatementNum, ProcStatus, DrugUnit, IcdVersion, ToothRange, ToothNum, ProvOrderOverride, BillingTypeTwo, PlaceService, SnomedBodySite, IsLocked, ProcTime, DateComplete, Priority, TaxAmt, IsCpoe, DiagnosticCode4, OldCode, ProcNumLab, ClinicNum, ProcDate, CodeMod3, StartTime, CodeNum, Discount, SiteNum, StopTime, MedicalCode, PatNum, UnitQty, IsPrincDiag, Prognosis, IsDateProsthEst, CodeMod2, BillingNote, UnitQtyType, CodeMod1, DateEntryC, RevCode, CodeMod4, PlannedAptNum, SecUserNumEntry, BillingTypeOne, SecDateEntry, HideGraphics, DiagnosticCode3, Dx, DiagnosticCode2, DrugQty, ProcFee), DELETE, SHOW VIEW ON `opendental`.`procedurelog` TO 'user'@'localhost';
  1082.  
  1083. GRANT ALL ON opendental.account TO 'user'@'::1';
  1084. GRANT ALL ON opendental.accountingautopay TO 'user'@'::1';
  1085. GRANT ALL ON opendental.adjustment TO 'user'@'::1';
  1086. GRANT ALL ON opendental.alertcategory TO 'user'@'::1';
  1087. GRANT ALL ON opendental.alertcategorylink TO 'user'@'::1';
  1088. GRANT ALL ON opendental.alertitem TO 'user'@'::1';
  1089. GRANT ALL ON opendental.alertread TO 'user'@'::1';
  1090. GRANT ALL ON opendental.alertsub TO 'user'@'::1';
  1091. GRANT ALL ON opendental.allergy TO 'user'@'::1';
  1092. GRANT ALL ON opendental.allergydef TO 'user'@'::1';
  1093. GRANT ALL ON opendental.anestheticdata TO 'user'@'::1';
  1094. GRANT ALL ON opendental.anestheticrecord TO 'user'@'::1';
  1095. GRANT ALL ON opendental.anesthmedsgiven TO 'user'@'::1';
  1096. GRANT ALL ON opendental.anesthmedsintake TO 'user'@'::1';
  1097. GRANT ALL ON opendental.anesthmedsinventory TO 'user'@'::1';
  1098. GRANT ALL ON opendental.anesthmedsinventoryadj TO 'user'@'::1';
  1099. GRANT ALL ON opendental.anesthmedsuppliers TO 'user'@'::1';
  1100. GRANT ALL ON opendental.anesthscore TO 'user'@'::1';
  1101. GRANT ALL ON opendental.anesthvsdata TO 'user'@'::1';
  1102. GRANT ALL ON opendental.appointment TO 'user'@'::1';
  1103. GRANT ALL ON opendental.appointmentrule TO 'user'@'::1';
  1104. GRANT ALL ON opendental.appointmenttype TO 'user'@'::1';
  1105. GRANT ALL ON opendental.apptfield TO 'user'@'::1';
  1106. GRANT ALL ON opendental.apptfielddef TO 'user'@'::1';
  1107. GRANT ALL ON opendental.apptreminderrule TO 'user'@'::1';
  1108. GRANT ALL ON opendental.apptremindersent TO 'user'@'::1';
  1109. GRANT ALL ON opendental.apptview TO 'user'@'::1';
  1110. GRANT ALL ON opendental.apptviewitem TO 'user'@'::1';
  1111. GRANT ALL ON opendental.asapcomm TO 'user'@'::1';
  1112. GRANT ALL ON opendental.autocode TO 'user'@'::1';
  1113. GRANT ALL ON opendental.autocodecond TO 'user'@'::1';
  1114. GRANT ALL ON opendental.autocodeitem TO 'user'@'::1';
  1115. GRANT ALL ON opendental.automation TO 'user'@'::1';
  1116. GRANT ALL ON opendental.automationcondition TO 'user'@'::1';
  1117. GRANT ALL ON opendental.autonote TO 'user'@'::1';
  1118. GRANT ALL ON opendental.autonotecontrol TO 'user'@'::1';
  1119. GRANT ALL ON opendental.benefit TO 'user'@'::1';
  1120. GRANT ALL ON opendental.canadiannetwork TO 'user'@'::1';
  1121. GRANT ALL ON opendental.carrier TO 'user'@'::1';
  1122. GRANT ALL ON opendental.cdcrec TO 'user'@'::1';
  1123. GRANT ALL ON opendental.cdspermission TO 'user'@'::1';
  1124. GRANT ALL ON opendental.centralconnection TO 'user'@'::1';
  1125. GRANT ALL ON opendental.chartview TO 'user'@'::1';
  1126. GRANT ALL ON opendental.claim TO 'user'@'::1';
  1127. GRANT ALL ON opendental.claimattach TO 'user'@'::1';
  1128. GRANT ALL ON opendental.claimcondcodelog TO 'user'@'::1';
  1129. GRANT ALL ON opendental.claimform TO 'user'@'::1';
  1130. GRANT ALL ON opendental.claimformitem TO 'user'@'::1';
  1131. GRANT ALL ON opendental.claimpayment TO 'user'@'::1';
  1132. GRANT ALL ON opendental.claimproc TO 'user'@'::1';
  1133. GRANT ALL ON opendental.claimsnapshot TO 'user'@'::1';
  1134. GRANT ALL ON opendental.claimtracking TO 'user'@'::1';
  1135. GRANT ALL ON opendental.claimvalcodelog TO 'user'@'::1';
  1136. GRANT ALL ON opendental.clearinghouse TO 'user'@'::1';
  1137. GRANT ALL ON opendental.clinic TO 'user'@'::1';
  1138. GRANT ALL ON opendental.clinicerx TO 'user'@'::1';
  1139. GRANT ALL ON opendental.clinicpref TO 'user'@'::1';
  1140. GRANT ALL ON opendental.clockevent TO 'user'@'::1';
  1141. GRANT ALL ON opendental.codesystem TO 'user'@'::1';
  1142. GRANT ALL ON opendental.commlog TO 'user'@'::1';
  1143. GRANT ALL ON opendental.commoptout TO 'user'@'::1';
  1144. GRANT ALL ON opendental.computer TO 'user'@'::1';
  1145. GRANT ALL ON opendental.computerpref TO 'user'@'::1';
  1146. GRANT ALL ON opendental.confirmationrequest TO 'user'@'::1';
  1147. GRANT ALL ON opendental.connectiongroup TO 'user'@'::1';
  1148. GRANT ALL ON opendental.conngroupattach TO 'user'@'::1';
  1149. GRANT ALL ON opendental.contact TO 'user'@'::1';
  1150. GRANT ALL ON opendental.county TO 'user'@'::1';
  1151. GRANT ALL ON opendental.covcat TO 'user'@'::1';
  1152. GRANT ALL ON opendental.covspan TO 'user'@'::1';
  1153. GRANT ALL ON opendental.cpt TO 'user'@'::1';
  1154. GRANT ALL ON opendental.creditcard TO 'user'@'::1';
  1155. GRANT ALL ON opendental.custrefentry TO 'user'@'::1';
  1156. GRANT ALL ON opendental.custreference TO 'user'@'::1';
  1157. GRANT ALL ON opendental.cvx TO 'user'@'::1';
  1158. GRANT ALL ON opendental.dashboardar TO 'user'@'::1';
  1159. GRANT ALL ON opendental.dashboardcell TO 'user'@'::1';
  1160. GRANT ALL ON opendental.dashboardlayout TO 'user'@'::1';
  1161. GRANT ALL ON opendental.databasemaintenance TO 'user'@'::1';
  1162. GRANT ALL ON opendental.dbmlog TO 'user'@'::1';
  1163. GRANT ALL ON opendental.definition TO 'user'@'::1';
  1164. GRANT ALL ON opendental.deflink TO 'user'@'::1';
  1165. GRANT ALL ON opendental.deletedobject TO 'user'@'::1';
  1166. GRANT ALL ON opendental.deposit TO 'user'@'::1';
  1167. GRANT ALL ON opendental.dictcustom TO 'user'@'::1';
  1168. GRANT ALL ON opendental.discountplan TO 'user'@'::1';
  1169. GRANT ALL ON opendental.disease TO 'user'@'::1';
  1170. GRANT ALL ON opendental.diseasedef TO 'user'@'::1';
  1171. GRANT ALL ON opendental.displayfield TO 'user'@'::1';
  1172. GRANT ALL ON opendental.displayreport TO 'user'@'::1';
  1173. GRANT ALL ON opendental.dispsupply TO 'user'@'::1';
  1174. GRANT ALL ON opendental.document TO 'user'@'::1';
  1175. GRANT ALL ON opendental.documentmisc TO 'user'@'::1';
  1176. GRANT ALL ON opendental.drugmanufacturer TO 'user'@'::1';
  1177. GRANT ALL ON opendental.drugunit TO 'user'@'::1';
  1178. GRANT ALL ON opendental.dunning TO 'user'@'::1';
  1179. GRANT ALL ON opendental.ebill TO 'user'@'::1';
  1180. GRANT ALL ON opendental.eduresource TO 'user'@'::1';
  1181. GRANT ALL ON opendental.ehramendment TO 'user'@'::1';
  1182. GRANT ALL ON opendental.ehraptobs TO 'user'@'::1';
  1183. GRANT ALL ON opendental.ehrcareplan TO 'user'@'::1';
  1184. GRANT ALL ON opendental.ehrlab TO 'user'@'::1';
  1185. GRANT ALL ON opendental.ehrlabclinicalinfo TO 'user'@'::1';
  1186. GRANT ALL ON opendental.ehrlabimage TO 'user'@'::1';
  1187. GRANT ALL ON opendental.ehrlabnote TO 'user'@'::1';
  1188. GRANT ALL ON opendental.ehrlabresult TO 'user'@'::1';
  1189. GRANT ALL ON opendental.ehrlabresultscopyto TO 'user'@'::1';
  1190. GRANT ALL ON opendental.ehrlabspecimen TO 'user'@'::1';
  1191. GRANT ALL ON opendental.ehrlabspecimencondition TO 'user'@'::1';
  1192. GRANT ALL ON opendental.ehrlabspecimenrejectreason TO 'user'@'::1';
  1193. GRANT ALL ON opendental.ehrmeasure TO 'user'@'::1';
  1194. GRANT ALL ON opendental.ehrmeasureevent TO 'user'@'::1';
  1195. GRANT ALL ON opendental.ehrnotperformed TO 'user'@'::1';
  1196. GRANT ALL ON opendental.ehrpatient TO 'user'@'::1';
  1197. GRANT ALL ON opendental.ehrprovkey TO 'user'@'::1';
  1198. GRANT ALL ON opendental.ehrquarterlykey TO 'user'@'::1';
  1199. GRANT ALL ON opendental.ehrsummaryccd TO 'user'@'::1';
  1200. GRANT ALL ON opendental.ehrtrigger TO 'user'@'::1';
  1201. GRANT ALL ON opendental.electid TO 'user'@'::1';
  1202. GRANT ALL ON opendental.emailaddress TO 'user'@'::1';
  1203. GRANT ALL ON opendental.emailattach TO 'user'@'::1';
  1204. GRANT ALL ON opendental.emailautograph TO 'user'@'::1';
  1205. GRANT ALL ON opendental.emailmessage TO 'user'@'::1';
  1206. GRANT ALL ON opendental.emailmessageuid TO 'user'@'::1';
  1207. GRANT ALL ON opendental.emailtemplate TO 'user'@'::1';
  1208. GRANT ALL ON opendental.employee TO 'user'@'::1';
  1209. GRANT ALL ON opendental.employer TO 'user'@'::1';
  1210. GRANT ALL ON opendental.encounter TO 'user'@'::1';
  1211. GRANT ALL ON opendental.entrylog TO 'user'@'::1';
  1212. GRANT ALL ON opendental.eobattach TO 'user'@'::1';
  1213. GRANT ALL ON opendental.equipment TO 'user'@'::1';
  1214. GRANT ALL ON opendental.erxlog TO 'user'@'::1';
  1215. GRANT ALL ON opendental.eservicesignal TO 'user'@'::1';
  1216. GRANT ALL ON opendental.etrans TO 'user'@'::1';
  1217. GRANT ALL ON opendental.etrans835attach TO 'user'@'::1';
  1218. GRANT ALL ON opendental.etransmessagetext TO 'user'@'::1';
  1219. GRANT ALL ON opendental.evaluation TO 'user'@'::1';
  1220. GRANT ALL ON opendental.evaluationcriterion TO 'user'@'::1';
  1221. GRANT ALL ON opendental.evaluationcriteriondef TO 'user'@'::1';
  1222. GRANT ALL ON opendental.evaluationdef TO 'user'@'::1';
  1223. GRANT ALL ON opendental.famaging TO 'user'@'::1';
  1224. GRANT ALL ON opendental.familyhealth TO 'user'@'::1';
  1225. GRANT ALL ON opendental.fee TO 'user'@'::1';
  1226. GRANT ALL ON opendental.feesched TO 'user'@'::1';
  1227. GRANT ALL ON opendental.fhircontactpoint TO 'user'@'::1';
  1228. GRANT ALL ON opendental.fhirsubscription TO 'user'@'::1';
  1229. GRANT ALL ON opendental.fielddeflink TO 'user'@'::1';
  1230. GRANT ALL ON opendental.files TO 'user'@'::1';
  1231. GRANT ALL ON opendental.formpat TO 'user'@'::1';
  1232. GRANT ALL ON opendental.gradingscale TO 'user'@'::1';
  1233. GRANT ALL ON opendental.gradingscaleitem TO 'user'@'::1';
  1234. GRANT ALL ON opendental.grouppermission TO 'user'@'::1';
  1235. GRANT ALL ON opendental.guardian TO 'user'@'::1';
  1236. GRANT ALL ON opendental.hcpcs TO 'user'@'::1';
  1237. GRANT ALL ON opendental.histappointment TO 'user'@'::1';
  1238. GRANT ALL ON opendental.hl7def TO 'user'@'::1';
  1239. GRANT ALL ON opendental.hl7deffield TO 'user'@'::1';
  1240. GRANT ALL ON opendental.hl7defmessage TO 'user'@'::1';
  1241. GRANT ALL ON opendental.hl7defsegment TO 'user'@'::1';
  1242. GRANT ALL ON opendental.hl7msg TO 'user'@'::1';
  1243. GRANT ALL ON opendental.hl7procattach TO 'user'@'::1';
  1244. GRANT ALL ON opendental.icd10 TO 'user'@'::1';
  1245. GRANT ALL ON opendental.icd9 TO 'user'@'::1';
  1246. GRANT ALL ON opendental.inseditlog TO 'user'@'::1';
  1247. GRANT ALL ON opendental.insfilingcode TO 'user'@'::1';
  1248. GRANT ALL ON opendental.insfilingcodesubtype TO 'user'@'::1';
  1249. GRANT ALL ON opendental.insplan TO 'user'@'::1';
  1250. GRANT ALL ON opendental.inssub TO 'user'@'::1';
  1251. GRANT ALL ON opendental.installmentplan TO 'user'@'::1';
  1252. GRANT ALL ON opendental.instructor TO 'user'@'::1';
  1253. GRANT ALL ON opendental.insverify TO 'user'@'::1';
  1254. GRANT ALL ON opendental.insverifyhist TO 'user'@'::1';
  1255. GRANT ALL ON opendental.intervention TO 'user'@'::1';
  1256. GRANT ALL ON opendental.journalentry TO 'user'@'::1';
  1257. GRANT ALL ON opendental.labcase TO 'user'@'::1';
  1258. GRANT ALL ON opendental.laboratory TO 'user'@'::1';
  1259. GRANT ALL ON opendental.labpanel TO 'user'@'::1';
  1260. GRANT ALL ON opendental.labresult TO 'user'@'::1';
  1261. GRANT ALL ON opendental.labturnaround TO 'user'@'::1';
  1262. GRANT ALL ON opendental.language TO 'user'@'::1';
  1263. GRANT ALL ON opendental.languageforeign TO 'user'@'::1';
  1264. GRANT ALL ON opendental.letter TO 'user'@'::1';
  1265. GRANT ALL ON opendental.lettermerge TO 'user'@'::1';
  1266. GRANT ALL ON opendental.lettermergefield TO 'user'@'::1';
  1267. GRANT ALL ON opendental.loinc TO 'user'@'::1';
  1268. GRANT ALL ON opendental.maparea TO 'user'@'::1';
  1269. GRANT ALL ON opendental.medicalorder TO 'user'@'::1';
  1270. GRANT ALL ON opendental.medication TO 'user'@'::1';
  1271. GRANT ALL ON opendental.medicationpat TO 'user'@'::1';
  1272. GRANT ALL ON opendental.medlab TO 'user'@'::1';
  1273. GRANT ALL ON opendental.medlabfacattach TO 'user'@'::1';
  1274. GRANT ALL ON opendental.medlabfacility TO 'user'@'::1';
  1275. GRANT ALL ON opendental.medlabresult TO 'user'@'::1';
  1276. GRANT ALL ON opendental.medlabspecimen TO 'user'@'::1';
  1277. GRANT ALL ON opendental.mobileappdevice TO 'user'@'::1';
  1278. GRANT ALL ON opendental.mount TO 'user'@'::1';
  1279. GRANT ALL ON opendental.mountdef TO 'user'@'::1';
  1280. GRANT ALL ON opendental.mountitem TO 'user'@'::1';
  1281. GRANT ALL ON opendental.mountitemdef TO 'user'@'::1';
  1282. GRANT ALL ON opendental.oidexternal TO 'user'@'::1';
  1283. GRANT ALL ON opendental.oidinternal TO 'user'@'::1';
  1284. GRANT ALL ON opendental.operatory TO 'user'@'::1';
  1285. GRANT ALL ON opendental.orionproc TO 'user'@'::1';
  1286. GRANT ALL ON opendental.orthochart TO 'user'@'::1';
  1287. GRANT ALL ON opendental.orthocharttab TO 'user'@'::1';
  1288. GRANT ALL ON opendental.orthocharttablink TO 'user'@'::1';
  1289. GRANT ALL ON opendental.patfield TO 'user'@'::1';
  1290. GRANT ALL ON opendental.patfielddef TO 'user'@'::1';
  1291. GRANT ALL ON opendental.patient TO 'user'@'::1';
  1292. GRANT ALL ON opendental.patientlink TO 'user'@'::1';
  1293. GRANT ALL ON opendental.patientnote TO 'user'@'::1';
  1294. GRANT ALL ON opendental.patientportalinvite TO 'user'@'::1';
  1295. GRANT ALL ON opendental.patientrace TO 'user'@'::1';
  1296. GRANT ALL ON opendental.patplan TO 'user'@'::1';
  1297. GRANT ALL ON opendental.patrestriction TO 'user'@'::1';
  1298. GRANT ALL ON opendental.payconnectresponseweb TO 'user'@'::1';
  1299. GRANT ALL ON opendental.payment TO 'user'@'::1';
  1300. GRANT ALL ON opendental.payortype TO 'user'@'::1';
  1301. GRANT ALL ON opendental.payperiod TO 'user'@'::1';
  1302. GRANT ALL ON opendental.payplan TO 'user'@'::1';
  1303. GRANT ALL ON opendental.payplancharge TO 'user'@'::1';
  1304. GRANT ALL ON opendental.paysplit TO 'user'@'::1';
  1305. GRANT ALL ON opendental.perioexam TO 'user'@'::1';
  1306. GRANT ALL ON opendental.periomeasure TO 'user'@'::1';
  1307. GRANT ALL ON opendental.pharmacy TO 'user'@'::1';
  1308. GRANT ALL ON opendental.pharmclinic TO 'user'@'::1';
  1309. GRANT ALL ON opendental.phonenumber TO 'user'@'::1';
  1310. GRANT ALL ON opendental.plannedappt TO 'user'@'::1';
  1311. GRANT ALL ON opendental.popup TO 'user'@'::1';
  1312. GRANT ALL ON opendental.preference TO 'user'@'::1';
  1313. GRANT ALL ON opendental.printer TO 'user'@'::1';
  1314. GRANT ALL ON opendental.procapptcolor TO 'user'@'::1';
  1315. GRANT ALL ON opendental.procbutton TO 'user'@'::1';
  1316. GRANT ALL ON opendental.procbuttonitem TO 'user'@'::1';
  1317. GRANT ALL ON opendental.procbuttonquick TO 'user'@'::1';
  1318. GRANT ALL ON opendental.proccodenote TO 'user'@'::1';
  1319. GRANT ALL ON opendental.procedurecode TO 'user'@'::1';
  1320. GRANT ALL ON opendental.procgroupitem TO 'user'@'::1';
  1321. GRANT ALL ON opendental.procmultivisit TO 'user'@'::1';
  1322. GRANT ALL ON opendental.procnote TO 'user'@'::1';
  1323. GRANT ALL ON opendental.proctp TO 'user'@'::1';
  1324. GRANT ALL ON opendental.program TO 'user'@'::1';
  1325. GRANT ALL ON opendental.programproperty TO 'user'@'::1';
  1326. GRANT ALL ON opendental.provider TO 'user'@'::1';
  1327. GRANT ALL ON opendental.providerclinic TO 'user'@'::1';
  1328. GRANT ALL ON opendental.providercliniclink TO 'user'@'::1';
  1329. GRANT ALL ON opendental.providererx TO 'user'@'::1';
  1330. GRANT ALL ON opendental.providerident TO 'user'@'::1';
  1331. GRANT ALL ON opendental.question TO 'user'@'::1';
  1332. GRANT ALL ON opendental.questiondef TO 'user'@'::1';
  1333. GRANT ALL ON opendental.quickpastecat TO 'user'@'::1';
  1334. GRANT ALL ON opendental.quickpastenote TO 'user'@'::1';
  1335. GRANT ALL ON opendental.reactivation TO 'user'@'::1';
  1336. GRANT ALL ON opendental.recall TO 'user'@'::1';
  1337. GRANT ALL ON opendental.recalltrigger TO 'user'@'::1';
  1338. GRANT ALL ON opendental.recalltype TO 'user'@'::1';
  1339. GRANT ALL ON opendental.reconcile TO 'user'@'::1';
  1340. GRANT ALL ON opendental.recurringcharge TO 'user'@'::1';
  1341. GRANT ALL ON opendental.refattach TO 'user'@'::1';
  1342. GRANT ALL ON opendental.referral TO 'user'@'::1';
  1343. GRANT ALL ON opendental.registrationkey TO 'user'@'::1';
  1344. GRANT ALL ON opendental.reminderrule TO 'user'@'::1';
  1345. GRANT ALL ON opendental.repeatcharge TO 'user'@'::1';
  1346. GRANT ALL ON opendental.replicationserver TO 'user'@'::1';
  1347. GRANT ALL ON opendental.reqneeded TO 'user'@'::1';
  1348. GRANT ALL ON opendental.reqstudent TO 'user'@'::1';
  1349. GRANT ALL ON opendental.requiredfield TO 'user'@'::1';
  1350. GRANT ALL ON opendental.requiredfieldcondition TO 'user'@'::1';
  1351. GRANT ALL ON opendental.reseller TO 'user'@'::1';
  1352. GRANT ALL ON opendental.resellerservice TO 'user'@'::1';
  1353. GRANT ALL ON opendental.rxalert TO 'user'@'::1';
  1354. GRANT ALL ON opendental.rxdef TO 'user'@'::1';
  1355. GRANT ALL ON opendental.rxnorm TO 'user'@'::1';
  1356. GRANT ALL ON opendental.rxpat TO 'user'@'::1';
  1357. GRANT ALL ON opendental.schedule TO 'user'@'::1';
  1358. GRANT ALL ON opendental.scheduleop TO 'user'@'::1';
  1359. GRANT ALL ON opendental.schoolclass TO 'user'@'::1';
  1360. GRANT ALL ON opendental.schoolcourse TO 'user'@'::1';
  1361. GRANT ALL ON opendental.screen TO 'user'@'::1';
  1362. GRANT ALL ON opendental.screengroup TO 'user'@'::1';
  1363. GRANT ALL ON opendental.screenpat TO 'user'@'::1';
  1364. GRANT ALL ON opendental.securitylog TO 'user'@'::1';
  1365. GRANT ALL ON opendental.securityloghash TO 'user'@'::1';
  1366. GRANT ALL ON opendental.sheet TO 'user'@'::1';
  1367. GRANT ALL ON opendental.sheetdef TO 'user'@'::1';
  1368. GRANT ALL ON opendental.sheetfield TO 'user'@'::1';
  1369. GRANT ALL ON opendental.sheetfielddef TO 'user'@'::1';
  1370. GRANT ALL ON opendental.sigbutdef TO 'user'@'::1';
  1371. GRANT ALL ON opendental.sigelementdef TO 'user'@'::1';
  1372. GRANT ALL ON opendental.sigmessage TO 'user'@'::1';
  1373. GRANT ALL ON opendental.signalod TO 'user'@'::1';
  1374. GRANT ALL ON opendental.site TO 'user'@'::1';
  1375. GRANT ALL ON opendental.smsblockphone TO 'user'@'::1';
  1376. GRANT ALL ON opendental.smsfrommobile TO 'user'@'::1';
  1377. GRANT ALL ON opendental.smsphone TO 'user'@'::1';
  1378. GRANT ALL ON opendental.smstomobile TO 'user'@'::1';
  1379. GRANT ALL ON opendental.snomed TO 'user'@'::1';
  1380. GRANT ALL ON opendental.sop TO 'user'@'::1';
  1381. GRANT ALL ON opendental.stateabbr TO 'user'@'::1';
  1382. GRANT ALL ON opendental.statement TO 'user'@'::1';
  1383. GRANT ALL ON opendental.stmtlink TO 'user'@'::1';
  1384. GRANT ALL ON opendental.substitutionlink TO 'user'@'::1';
  1385. GRANT ALL ON opendental.supplier TO 'user'@'::1';
  1386. GRANT ALL ON opendental.supply TO 'user'@'::1';
  1387. GRANT ALL ON opendental.supplyneeded TO 'user'@'::1';
  1388. GRANT ALL ON opendental.supplyorder TO 'user'@'::1';
  1389. GRANT ALL ON opendental.supplyorderitem TO 'user'@'::1';
  1390. GRANT ALL ON opendental.task TO 'user'@'::1';
  1391. GRANT ALL ON opendental.taskancestor TO 'user'@'::1';
  1392. GRANT ALL ON opendental.taskhist TO 'user'@'::1';
  1393. GRANT ALL ON opendental.tasklist TO 'user'@'::1';
  1394. GRANT ALL ON opendental.tasknote TO 'user'@'::1';
  1395. GRANT ALL ON opendental.tasksubscription TO 'user'@'::1';
  1396. GRANT ALL ON opendental.taskunread TO 'user'@'::1';
  1397. GRANT ALL ON opendental.terminalactive TO 'user'@'::1';
  1398. GRANT ALL ON opendental.timeadjust TO 'user'@'::1';
  1399. GRANT ALL ON opendental.timecardrule TO 'user'@'::1';
  1400. GRANT ALL ON opendental.toolbutitem TO 'user'@'::1';
  1401. GRANT ALL ON opendental.toothgridcell TO 'user'@'::1';
  1402. GRANT ALL ON opendental.toothgridcol TO 'user'@'::1';
  1403. GRANT ALL ON opendental.toothgriddef TO 'user'@'::1';
  1404. GRANT ALL ON opendental.toothinitial TO 'user'@'::1';
  1405. GRANT ALL ON opendental.transaction TO 'user'@'::1';
  1406. GRANT ALL ON opendental.treatplan TO 'user'@'::1';
  1407. GRANT ALL ON opendental.treatplanattach TO 'user'@'::1';
  1408. GRANT ALL ON opendental.tsitranslog TO 'user'@'::1';
  1409. GRANT ALL ON opendental.ucum TO 'user'@'::1';
  1410. GRANT ALL ON opendental.updatehistory TO 'user'@'::1';
  1411. GRANT ALL ON opendental.userclinic TO 'user'@'::1';
  1412. GRANT ALL ON opendental.usergroup TO 'user'@'::1';
  1413. GRANT ALL ON opendental.usergroupattach TO 'user'@'::1';
  1414. GRANT ALL ON opendental.userod TO 'user'@'::1';
  1415. GRANT ALL ON opendental.userodapptview TO 'user'@'::1';
  1416. GRANT ALL ON opendental.userodpref TO 'user'@'::1';
  1417. GRANT ALL ON opendental.userquery TO 'user'@'::1';
  1418. GRANT ALL ON opendental.userweb TO 'user'@'::1';
  1419. GRANT ALL ON opendental.vaccinedef TO 'user'@'::1';
  1420. GRANT ALL ON opendental.vaccineobs TO 'user'@'::1';
  1421. GRANT ALL ON opendental.vaccinepat TO 'user'@'::1';
  1422. GRANT ALL ON opendental.vitalsign TO 'user'@'::1';
  1423. GRANT ALL ON opendental.webschedrecall TO 'user'@'::1';
  1424. GRANT ALL ON opendental.wikilistheaderwidth TO 'user'@'::1';
  1425. GRANT ALL ON opendental.wikilisthist TO 'user'@'::1';
  1426. GRANT ALL ON opendental.wikipage TO 'user'@'::1';
  1427. GRANT ALL ON opendental.wikipagehist TO 'user'@'::1';
  1428. GRANT ALL ON opendental.xchargetransaction TO 'user'@'::1';
  1429. GRANT ALL ON opendental.xwebresponse TO 'user'@'::1';
  1430. GRANT ALL ON opendental.zipcode TO 'user'@'::1';
  1431. GRANT SELECT, SELECT (RepeatChargeNum, ProvNum, DateTP, ProcNum, ClaimNote, AptNum, DiagnosticCode, DateOriginalProsth, OrderingReferralNum, ProcTimeEnd, BaseUnits, Prosthesis, CanadianTypeCodes, Surf, StatementNum, ProcStatus, DrugUnit, IcdVersion, ToothRange, ToothNum, ProvOrderOverride, BillingTypeTwo, PlaceService, SnomedBodySite, IsLocked, ProcTime, DateComplete, Priority, TaxAmt, IsCpoe, DiagnosticCode4, OldCode, ProcNumLab, ClinicNum, ProcDate, CodeMod3, StartTime, CodeNum, Discount, SiteNum, StopTime, MedicalCode, PatNum, UnitQty, IsPrincDiag, Prognosis, IsDateProsthEst, CodeMod2, BillingNote, UnitQtyType, CodeMod1, DateEntryC, RevCode, DateTStamp, CodeMod4, PlannedAptNum, SecUserNumEntry, BillingTypeOne, SecDateEntry, HideGraphics, DiagnosticCode3, Dx, DiagnosticCode2, DrugQty, ProcFee), INSERT, UPDATE (RepeatChargeNum, ProvNum, DateTP, ProcNum, ClaimNote, AptNum, DiagnosticCode, DateOriginalProsth, OrderingReferralNum, ProcTimeEnd, BaseUnits, Prosthesis, CanadianTypeCodes, Surf, StatementNum, ProcStatus, DrugUnit, IcdVersion, ToothRange, ToothNum, ProvOrderOverride, BillingTypeTwo, PlaceService, SnomedBodySite, IsLocked, ProcTime, DateComplete, Priority, TaxAmt, IsCpoe, DiagnosticCode4, OldCode, ProcNumLab, ClinicNum, ProcDate, CodeMod3, StartTime, CodeNum, Discount, SiteNum, StopTime, MedicalCode, PatNum, UnitQty, IsPrincDiag, Prognosis, IsDateProsthEst, CodeMod2, BillingNote, UnitQtyType, CodeMod1, DateEntryC, RevCode, CodeMod4, PlannedAptNum, SecUserNumEntry, BillingTypeOne, SecDateEntry, HideGraphics, DiagnosticCode3, Dx, DiagnosticCode2, DrugQty, ProcFee), DELETE, SHOW VIEW ON `opendental`.`procedurelog` TO 'user'@'::1';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!