--drop user sjjh cascade;
--第一步:创建用户
create user sjjh identified by "123";
--第二步:给用户赋予会话权限
grant create session to sjjh;
--第三步:赋予操作表的权限
grant select on nguser.t_xtcs to sjjh;
grant select,update on nguser.t_yhxxb to sjjh;
grant select,insert,delete,update on nguser.t_temp to sjjh;
--第一步:创建用户
create user sjjh identified by "123";
--第二步:给用户赋予会话权限
grant create session to sjjh;
--第三步:赋予操作表的权限
grant select on nguser.t_xtcs to sjjh;
grant select,update on nguser.t_yhxxb to sjjh;
grant select,insert,delete,update on nguser.t_temp to sjjh;