oracle创建新用户并给该用户授权指定的几张表

-----新建用户只能查看指定的表------------

create user test identified by Tdba;  
grant connect,resource to test;
grant select on yw.JFKH to test;
grant select on yw.JFKH_DETAIL to test;

-----新建用户可以查看、修改指定的表------------

create user test identified by testdba;  
grant connect,resource to test;
grant select ,update on yws.JFKH to test;
grant select,update on yws.JFKH_DETAIL to test;