--
--Grant table permissions to roles
--
GRANT SELECT ON xcmanager.xc_ver TO XCUSERS
;
GRANT SELECT,INSERT,UPDATE,DELETE ON xcmanager.xc_ver TO XCMANAGERS
;
GRANT SELECT ON xcmanager.xc_sites TO XCUSERS
;
GRANT SELECT,INSERT,UPDATE,DELETE ON xcmanager.xc_sites TO XCMANAGERS
;
GRANT SELECT ON xcmanager.xc_sitesensors TO XCUSERS
;
GRANT SELECT,INSERT,UPDATE,DELETE ON xcmanager.xc_sitesensors TO XCMANAGERS
;
GRANT SELECT ON xcmanager.xc_data1 TO XCUSERS
;
GRANT SELECT,INSERT,UPDATE,DELETE ON xcmanager.xc_data1 TO XCMANAGERS
;
GRANT SELECT ON xcmanager.xc_txtdata1 TO XCUSERS
;
GRANT SELECT,INSERT,UPDATE,DELETE ON xcmanager.xc_txtdata1 TO XCMANAGERS
;
GRANT SELECT ON xcmanager.xc_pplist TO XCUSERS
;
GRANT SELECT,INSERT,UPDATE,DELETE ON xcmanager.xc_pplist TO XCMANAGERS
;
GRANT SELECT ON xcmanager.xc_ppdata1 TO XCUSERS
;
GRANT SELECT,INSERT,UPDATE,DELETE ON xcmanager.xc_ppdata1 TO XCMANAGERS
;
GRANT SELECT ON xcmanager.xc_goesqc TO XCUSERS
;
GRANT SELECT,INSERT,UPDATE,DELETE ON xcmanager.xc_goesqc TO XCMANAGERS
;
GRANT SELECT ON xcmanager.xc_rtuqc TO XCUSERS
;
GRANT SELECT,INSERT,UPDATE,DELETE ON xcmanager.xc_rtuqc TO XCMANAGERS
;
GRANT SELECT ON xcmanager.xc_sitesensorsdecode TO XCUSERS
;
GRANT SELECT,INSERT,UPDATE,DELETE ON xcmanager.xc_sitesensorsdecode TO XCMANAGERS
;
GRANT SELECT ON xcmanager.xc_pollgroups TO XCUSERS
;
GRANT SELECT,INSERT,UPDATE,DELETE ON xcmanager.xc_pollgroups TO XCMANAGERS
;
GRANT SELECT ON xcmanager.xc_recordids TO XCUSERS
;
GRANT SELECT,INSERT,UPDATE,DELETE ON xcmanager.xc_recordids TO XCMANAGERS
;
GRANT SELECT ON xcmanager.xc_log TO XCUSERS
;
GRANT SELECT,INSERT,UPDATE,DELETE ON xcmanager.xc_log TO XCMANAGERS
;
GRANT SELECT ON xcmanager.xc_users TO XCUSERS
;
GRANT SELECT,INSERT,UPDATE,DELETE ON xcmanager.xc_users TO XCMANAGERS
;
GRANT SELECT ON xcmanager.xc_templates TO XCUSERS
;
GRANT SELECT,INSERT,UPDATE,DELETE ON xcmanager.xc_templates TO XCMANAGERS
;
GRANT SELECT ON xcmanager.xc_lastvalues TO XCUSERS
;
GRANT SELECT,INSERT,UPDATE,DELETE ON xcmanager.xc_lastvalues TO XCMANAGERS
;

