Oracle

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