create role nurse; //创建一个角色
//给角色赋予权利
grant insert on table1 to nurse;
grant update on table1 to nurse;
grant delete on table2 to nurse;
//角色赋给用户
grant nurse to zhangsan;
grant nurse to lisi;
//procedure 执行权利
grant execute on procedure1 to nurse;