
use base_formation;
select * from formation;
truncate formation;
insert into formation (cours) values('MySql Admin'),('PHP'),('AJAX'),('Oracle');
-- Création de la vue --
create or replace view vue1 as select cours from formation;
select * from vue1;
-- Droits --
revoke select on base_formation.* from 'anne_marie'@'localhost';
grant select on base_formation.vue1 to 'anne_marie'@'localhost';

