oracle 对表赋权限

grant select on yizhen123.tpp_t_dz_liandong to wangyd;
grant select on yizhen123.tpp_t_dz_yilian to wangyd;
grant select on yizhen123.tpp_t_dz_yinglian to wangyd;

grant update on yizhen123.tpp_t_dz_liandong to wangyd;
grant update on yizhen123.tpp_t_dz_yilian to wangyd;
grant update on yizhen123.tpp_t_dz_yinglian to wangyd;

grant delete on yizhen123.tpp_t_dz_liandong to wangyd;
grant delete on yizhen123.tpp_t_dz_yilian to wangyd;
grant delete on yizhen123.tpp_t_dz_yinglian to wangyd;

grant insert on yizhen123.tpp_t_dz_liandong to wangyd;
grant insert on yizhen123.tpp_t_dz_yilian to wangyd;
grant insert on yizhen123.tpp_t_dz_yinglian to wangyd;

oracle 对表赋权限

标签：