Oracle新建用户赋只读某几张表的权限
create user JSETI_WZQ identified by abcdef; -- 假设abcdef是密码 grant connect,resource to JSETI_WZQ; grant select on LYSDC.ly_xxbz_gxjg_grtxfszl to JSETI_WZQ; grant select on LYSDC.ly_xxbz_gxjg_jzgjcsjzl to JSETI_WZQ; grant select on LYSDC.LY_XXBZ_GXXX_DWJBSJZL to JSETI_WZQ; grant select on LYSDC.ly_xxbz_gxxs_xsjbsjzl to JSETI_WZQ;