
-- sismap
-- REVOKE ALL PRIVILEGES, GRANT OPTION  FROM 'sismap'@'%.ingv.it';
GRANT EXECUTE ON PROCEDURE `sp_ew_last_event_id` TO 'sismap'@'%.ingv.it' IDENTIFIED BY 'sismapPWD';
GRANT EXECUTE ON PROCEDURE `sp_ew_event` TO 'sismap'@'%.ingv.it';
GRANT EXECUTE ON PROCEDURE `sp_ew_event_instance` TO 'sismap'@'%.ingv.it';
GRANT EXECUTE ON PROCEDURE `sp_ew_instance` TO 'sismap'@'%.ingv.it';

-- sispick
-- REVOKE ALL PRIVILEGES, GRANT OPTION  FROM 'sispick'@'%.ingv.it';
GRANT EXECUTE ON PROCEDURE `sp_ew_last_event_id` TO 'sispick'@'%.ingv.it' IDENTIFIED BY 'sispickPWD';
GRANT EXECUTE ON PROCEDURE `sp_ew_event_list` TO 'sispick'@'%.ingv.it';
GRANT EXECUTE ON PROCEDURE `sp_ew_event` TO 'sispick'@'%.ingv.it';
GRANT EXECUTE ON PROCEDURE `sp_ew_event_instance` TO 'sispick'@'%.ingv.it';
GRANT EXECUTE ON PROCEDURE `sp_ew_instance` TO 'sispick'@'%.ingv.it';

-- cmplocations
-- REVOKE ALL PRIVILEGES, GRANT OPTION  FROM 'cmplocations'@'%.ingv.it';
GRANT SELECT ON `vw_cmplocations` TO 'cmplocations'@'%.ingv.it' IDENTIFIED BY 'andersonPWD';

FLUSH PRIVILEGES;
