ztyzly00 2020-06-05
1、为在mysql创建test1账号,并赋予10.96.90.78,只读amp库中alert_info_tab表的权限
grant select on amp.alert_info_tab to identified by "123456";
2、取消10.96.90.78,只读amp库中alert_info_tab表的权限
REVOKE SELECT ON amp.alert_info_tab FROM ;
3、显示10.96.90.78 ,使用test1账号有什么权限
show grants for ;