create user func_1@localhost identified by 'func1';
create user func_2@localhost identified by 'func2';
create user func_3@localhost identified by 'func3';
create user func_4@localhost identified by 'func4';
create user func_5@localhost identified by 'func5';
create user func_6@localhost identified by 'func6';
create user func_7@localhost identified by 'func7';
create user func_8@localhost identified by 'func8';
create user func_9@localhost identified by 'func9';
create user func_10@localhost identified by 'func10';

create role 'Administrador','Desenvolvedor','Designer','Desenvolvedor estagiário', 'Revisor';

grant all on livraria_prof.* to Administrador with grant option;
grant all on restaurantes.* to Administrador with grant option;
grant Administrador to func_1@localhost,func_6@localhost; /*func_1, func_6 = Administrador*/
set default role Administrador for func_1@localhost; /*MariaDB Sintax*/
set default role Administrador for func_6@localhost; /*MariaDB Sintax*/

grant alter,create,drop,trigger,show view,create view,create routine, alter routine,execute,select,insert,update,delete,execute on livraria_prof.* to Desenvolvedor;
grant alter,create,drop,trigger,show view,create view,create routine, alter routine,execute,select,insert,update,delete,execute on restaurantes.* to Desenvolvedor;
grant Desenvolvedor to func_2@localhost,func_7@localhost; /*Func_2, func_7 = Desenvolvedor*/
set default role Desenvolvedor for func_2@localhost; /*MariaDB Sintax*/
set default role Desenvolvedor for func_7@localhost; /*MariaDB Sintax*/

grant alter,create,trigger,show view,create view,create routine, alter routine,execute,select,insert,update,execute on livraria_prof.* to 'Desenvolvedor estagiário';
grant alter,create,trigger,show view,create view,create routine, alter routine,execute,select,insert,update,execute on restaurantes.* to 'Desenvolvedor estagiário';
grant 'Desenvolvedor estagiário' to func_3@localhost,func_8@localhost; /*Func_3, func_8 = Desenvoledor estagiário*/
set default role 'Desenvolvedor estagiário' for func_3@localhost; /*MariaDB Sintax*/
set default role 'Desenvolvedor estagiário' for func_8@localhost; /*MariaDB Sintax*/

grant alter,create,drop,select,insert,update on livraria_prof.* to Revisor;
grant alter,create,drop,select,insert,update on restaurantes.* to Revisor;
grant Revisor to func_4@localhost,func_9@localhost; /*Func_4, func_9 = Revisor*/
set default role Revisor for func_4@localhost; /*MariaDB Sintax*/
set default role Revisor for func_9@localhost; /*MariaDB Sintax*/

grant select on livraria_prof.* to Designer;
grant select on restaurantes.* to Designer;
grant Designer to func_5@localhost, func_10@localhost; /*Func_5, func_10 = Designer*/
set default role Designer for func_5@localhost; /*MariaDB Sintax*/
set default role Designer for func_10@localhost; /*MariaDB Sintax*/