1. 授予表和列权限
权限:select , insert ,delete ,update , references ,create, alter ,index, drop , all 或 all privileges.
例: grant select on table_1 to user1;
grant update(name,age) on table_userinfo to Jim; //授予对列的更新权限。
2.授予数据库权限:
权限:select , insert , delete ,update ,references ,create ,alter ,drop , index, create temporary tables, create view , show view , create routine ,alter routine ,execute routine,
lock tables , all 或 all privileges .
例: grant select on testbase.* to Jim;
3.权限回收:
revoke select on table_1 from Jim;
revoke select on testbase from Jim;