-- access to the XConnect tables
GRANT SELECT ON XC_SITES TO XCONNECT_USER;
GRANT SELECT ON XC_SITESENSORS TO XCONNECT_USER;
GRANT SELECT ON XC_DATA1 TO XCONNECT_USER;
GRANT SELECT ON XC_DATA2 TO XCONNECT_USER;
GRANT SELECT ON XC_DATA3 TO XCONNECT_USER;
GRANT SELECT ON XC_DATA4 TO XCONNECT_USER;
GRANT SELECT ON XC_DATA5 TO XCONNECT_USER;
GRANT SELECT ON XC_DATA6 TO XCONNECT_USER;
GRANT SELECT ON XC_DATA7 TO XCONNECT_USER;
GRANT SELECT ON XC_DATA8 TO XCONNECT_USER;
GRANT SELECT ON XC_DATA9 TO XCONNECT_USER;
GRANT SELECT ON XC_DATA10 TO XCONNECT_USER;
GRANT SELECT ON XC_DATA11 TO XCONNECT_USER;
GRANT SELECT ON XC_DATA12 TO XCONNECT_USER;
GRANT SELECT ON XC_GOESQC TO XCONNECT_USER;
GRANT SELECT ON XC_PP_INSTRUCTIONS TO XCONNECT_USER;
GRANT ALTER  ON XC_PP_INSTRUCTIONS TO XCONNECT_USER;
GRANT DELETE ON XC_PP_INSTRUCTIONS TO XCONNECT_USER;
GRANT INSERT ON XC_PP_INSTRUCTIONS TO XCONNECT_USER;
GRANT UPDATE ON XC_PP_INSTRUCTIONS TO XCONNECT_USER;
GRANT SELECT ON XC_SITSENS_PPI TO XCONNECT_USER;
GRANT ALTER  ON XC_SITSENS_PPI TO XCONNECT_USER;
GRANT DELETE ON XC_SITSENS_PPI TO XCONNECT_USER;
GRANT INSERT ON XC_SITSENS_PPI TO XCONNECT_USER;
GRANT UPDATE ON XC_SITSENS_PPI TO XCONNECT_USER;
GRANT SELECT ON XC_SENSOR_TEMPLATES TO XCONNECT_USER;
GRANT SELECT ON XC_PPDATA1 TO XCONNECT_USER;
GRANT SELECT ON XC_TXTDATA1 TO XCONNECT_USER;
