[grant mysql privilage] How to grant some privilage for user with mysql. #mysql #grant - Cacher Snippet

7/2/2019 - 12:13 PM

[grant mysql privilage] How to grant some privilage for user with mysql. #mysql #grant

[grant mysql privilage] How to grant some privilage for user with mysql. #mysql #grant

grant-privilages.sql

-- 授权用户查询权限
grant select on akernel.settlement to akernel_bd@'%';

-- 授权用户函数执行权限
grant execute on function akernel.nextval to akernel_bd@'%';

-- 取消用户查询权限
revoke select on akernel.settlement from akernel_bd@'%';