conn u_b/pwd@orclgrant select on t_b to u_b;
grant delete on t_b to u_b;
grant update on t_b to u_b;conn u_a/pwd@orcl
create synonym t_b for u_b.t_b;
create synonym seq_b1 for u_b.seq_b1;我做的对吗?
===========================================
grant delete on t_b to u_b;
grant update on t_b to u_b;conn u_a/pwd@orcl
create synonym t_b for u_b.t_b;
create synonym seq_b1 for u_b.seq_b1;我做的对吗?
===========================================
minvalue 1
maxvalue 9999999999
start with 2000
increment by 1
cache 20
cycle;
===============================
grant select on u_b.t_b to u_a;
grant delete on u_b.t_b to u_a;
grant update on u_b.t_b to u_a;conn u_a/pwd@orcl
create synonym t_b for u_b.t_b;
create synonym seq_b1 for u_b.seq_b1;
我等一天了,我找到办法了,你才来。气死我了。
毕竟我们也有自己的事情,不可能整天都挂在csdn上的啊。