console.sql

CREATE ROLE gestionnaire_des_interventions;
GRANT SELECT ON EMPLOYE
  TO gestionnaire_des_interventions ;
GRANT SELECT ON VEHICULE
  TO gestionnaire_des_interventions ;
GRANT SELECT ON CLIENT
  TO gestionnaire_des_interventions ;
GRANT UPDATE ON INTERVENTIONS
  TO gestionnaire_des_interventions ;
GRANT UPDATE ON INTERVENANTS
  TO gestionnaire_des_interventions ;