使用DB链接的同义词执行过程

Question

我在DB链接上执行过程有问题

，我有三个数据库：

db1，db2和db3

• db1是源数据库，其中该过程
• db2是“网关”数据库
• db3是数据库，来自DB1的数据库是从DB1执行的。 的db链接

db2 db1：

create user DB1EXECUTOR identified by "password";
grant connect, create session to DB1EXECUTOR;
grant execute on DB1SOURCE.PROCEDURE1 to DB1EXECUTOR;

db2：

create user DB3_TO_DB1_CONNECTOR identified by "password";
grant connect, create session, create synonym, create database link to DB3_TO_DB1_CONNECTOR;

=====using DB3_TO_DB1_CONNECTOR user:=====
create database link DB2_TO_DB1_DBLINK connect to DB1EXECUTOR identified by "password" using 'DB1';
create synonym PROCEDURE1 for PROCEDURE1@DB2_TO_DB1_DBLINK;

db3

create user DB3APP identified by "password";
grant connect, create session, create synonym, create database link to DB3APP;

=====using DB3APP user:=====
create database link DB3_TO_DB2_DBLINK connect to DB3_TO_DB1_CONNECTOR identified by "password" using 'DB2';
create synonym PROCEDURE1 for PROCEDURE1@DB3_TO_DB2_DBLINK;

：最后，当我尝试通过db2从db链接执行db1的过程1时，一切都很好：

=====using DB2 database and DB3_TO_DB1_CONNECTOR user:=====
execute PROCEDURE1

ok

但是，当我尝试通过db3从db3上执行相同的过程时，这不是工作...

=====using DB3 database and DB3APP user:=====
execute PROCEDURE1

...
PLS-00352: Unable access to another database "DB2_TO_DB1_DBLINK"
...
PLS-00201: identifier "PROCEDURE1" must be declared
...

这里怎么了？ 我不忽略为什么我可以从db2执行Procemure1，而不是从DB3 ...