我認為：開發(fā)人員需要所有權(quán)限，所以沒必要通過角色授權(quán)，直接授予所有權(quán)限即可.
create user 'dev01' @ 'appdb' indentified by '123456';
create user 'dev02' @ 'appdb' indentified by '123456';
create user 'dev03' @ 'appdb' indentified by '123456';
grant all privileges on appdb.* to 'dev01';
grant all privileges on appdb.* to 'dev02';
grant all privileges on appdb.* to 'dev03';
然后再創(chuàng)建兩個角色，一個只讀權(quán)限，一個讀寫權(quán)限。
create role 'read_role';
grant select on appdb.*? to 'read_role';
create role 'write_role';
grant insert,update,delete,select on appdb.* to 'write_role';

grant 'read_role' to 'read01';
grant 'read_role' to 'read02';

grant 'write_role' to 'write01';
grant 'write_role' to 'write02';

請問：授權(quán)可以同時寫多個角色和多個用戶嗎？比如這么寫：
grant? 'read_role','write_role' to 'dev01';
grant? 'read_role','write_role' to 'dev01',dev02;
grant 'write_role' to 'write01','write02';