mysql&mariadb常用权限管理

创建用户并授查询视图或表的权限：
create user 'platform'@'%' identified by 'platform@20220621';
授查询所有表：
grant select on hnkjxyzhxy.* to 'platform'@'%';
flush privileges ;

授权查询表或视图：
GRANT select,SHOW VIEW ON hnkjxyzhxy.v_sys_dict_data TO 'platform'@'%';
GRANT select,SHOW VIEW ON hnkjxyzhxy.v_jbxx_xsjbxx TO 'platform'@'%';
GRANT select,SHOW VIEW ON hnkjxyzhxy.v_t_yx_blrz TO 'platform'@'%';
GRANT select,SHOW VIEW ON hnkjxyzhxy.v_zhyx_yxhjblxx TO 'platform'@'%';
flush privileges ;