?????????a?н?????飬?????
SQL> exec proc('mmm');
PL/SQL procedure successfully completed
SQL> select * from a;
COL
----------------------------------------
JJJ
mmm
iii
????????????b?У????в????
SQL> conn b/b@sicsdb
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.4.0
Connected as b
SQL> exec proc('NNN');
PL/SQL procedure successfully completed
SQL> select * from a;
COL
----------------------------------------
NNN
SQL> select * from a.a
2  ;
COL
--------------------
JJJ
mmm
iii
?????????????????????????￡???????????Schema????????????Ч??????????Schema B??????????a??Ч????Σ?
????SQL> drop table a;
????Table dropped
????SQL> exec proc('mt');
????begin proc('mt'); end;
????ORA-00942: ????????????
????ORA-06512: ?? "A.PROC"?? line 3
????ORA-06512: ?? line 1
???????b?????????a????μ??????a???????????????
SQL> conn a/a@sicsdb
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.4.0
Connected as a
SQL> grant all on a to b;
Grant succeeded
SQL> conn b/b@sicsdb
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.4.0
Connected as b
SQL> exec proc('mt');
begin proc('mt'); end;
ORA-00942: ????????????
ORA-06512: ?? "A.PROC"?? line 3
ORA-06512: ?? line 1
????4??????
?????????????????????????Oracle?洢??????????????????????Щ?鷳??????????????в????Ч????