8.0中如何给只读用户app_ro 授权只能查询oadb库中表的权限 ,读写用户app_wr 授权能正常查询和修改oadb库中所有表的权限?
假设你的只读用户是’app_ro’@’%’,则授权语句为:
GRANT SELECT, SHOW VIEW ON `oadb`.* TO 'app_ro'@'%';
假设你的读写用户是’app_wr’@’%’,则授权语句为:
GRANT ALTER, CREATE, DELETE, DROP, INDEX, INSERT, UPDATE, TRIGGER, REFERENCES, EVENT, CREATE VIEW, CREATE TEMPORARY TABLES, CREATE ROUTINE, ALTER ROUTINE, EXECUTE ON `app_ro`.* TO 'app_wr'@'%';