mysql 增加只读用户查询指定表

GRANT SELECT ON dsideal_db.t_base_organization TO 'guanli'@'%' IDENTIFIED BY '123456';
GRANT SELECT ON dsideal_db.t_base_class TO 'guanli'@'%' IDENTIFIED BY '123456';
GRANT SELECT ON dsideal_db.t_sys_role TO 'guanli'@'%' IDENTIFIED BY '123456';
GRANT SELECT ON dsideal_db.t_sys_person_role TO 'guanli'@'%' IDENTIFIED BY '123456';
GRANT SELECT ON dsideal_db.t_base_person TO 'guanli'@'%' IDENTIFIED BY '123456';
GRANT SELECT ON dsideal_db.t_base_student TO 'guanli'@'%' IDENTIFIED BY '123456';
GRANT SELECT ON dsideal_db.t_base_parent TO 'guanli'@'%' IDENTIFIED BY '123456';
GRANT SELECT ON dsideal_db.t_sys_loginperson TO 'guanli'@'%' IDENTIFIED BY '123456';
GRANT SELECT ON dsideal_db.t_sys_role_purview TO 'guanli'@'%' IDENTIFIED BY '123456';

flush privileges;

上一篇:IK Analyzer 和 lucene结合使用


下一篇:AE指定字段转成注记