CREATE ROLE visu_machines;
GRANT SELECT ON t_e_versionvm_vvm TO visu_machines;
GRANT SELECT ON t_e_machinevirtuelle_mav TO visu_machines;
GRANT SELECT ON t_r_plateforme_pla TO visu_machines;
CREATE ROLE visu_demandeurs;
GRANT SELECT ON t_e_dmandeur_dem TO visu_demandeurs;
CREATE ROLE upd_demandeur;
GRANT UPDATE(dem_mail, dem_type, dem_rue, dem_cp, dem_ville, dem_telfixe, dem_entreprise, dem_numbureau, dem_mobile) TO upd_demandeurs;
CREATE ROLE visu_installations;
GRANT SELECT ON t_e_logiciel_log, t_j_installation_ins TO visu_installations;
CREATE ROLE maj_machines;
GRANT INSERT, UPDATE, DELETE ON t_e_machinevirtuelle_mav TO maj_machines;
CREATE ROLE PUBLICVIRTUALISATION;
GRANT visu_machines to PublicVirtualisation;
CREATE ROLE MEMBRES;
GRANT visu_machines, visu_demandeurs, upd_demandeurs, visu_installations to MEMBRES;
CREATE USER user1 WITH LOGIN PASSWORD 'password';
GRANT PublicVirtualisation to user1;
CREATE USER user2 WITH LOGIN PASSWORD 'password';
GRANT Membres to user2;