1.创建用户 create user user_name identified by user_password; 2.赋予权限 赋予查询权限 grant select on table_name to username 赋予更新权限 grant update on table_name to username 赋予插入权限 grant insert on table_name to username 赋予删除权限 grant delete on table_name to username