salix/db/versions/10878-blueSalal/00-firstScript.sql

DELIMITER $$
CREATE OR REPLACE DEFINER=`root`@`localhost` PROCEDURE `vn`.`supplier_statement`()
BEGIN
	SELECT 1;
END$$
DELIMITER ;

GRANT EXECUTE ON PROCEDURE vn.supplier_statement TO administrative, buyer, hrBoss;

DELIMITER $$
CREATE OR REPLACE DEFINER=`root`@`localhost` PROCEDURE `vn`.`XDiario_check`()
BEGIN
	SELECT 1;
END$$
DELIMITER ;

GRANT EXECUTE ON PROCEDURE vn.XDiario_check TO adminBoss;

DELIMITER $$
CREATE OR REPLACE DEFINER=`root`@`localhost` PROCEDURE `vn`.`travel_getDetailFromContinent`()
BEGIN
	SELECT 1;
END$$
DELIMITER ;

GRANT EXECUTE ON PROCEDURE vn.travel_getDetailFromContinent TO buyer;

DELIMITER $$
CREATE OR REPLACE DEFINER=`root`@`localhost` PROCEDURE `vn`.`entry_getTransfer`()
BEGIN
	SELECT 1;
END$$
DELIMITER ;

GRANT EXECUTE ON PROCEDURE vn.entry_getTransfer TO claimManager, buyer;