PLS-00201 error

I have this situation: I created a synonym for schema2.table_name and i use it in a procedure owned by schema1. Schema1 is dba and has the grant to select any table by dba role. When i execute the procedure i get the PLS-00201 error because i cannot access to schema2.table_name with the grant given by the dba role, and so i have to explicitly grant schema1 user to select any table ecc... But the weird issue is another one. If i create a synonym like schema2.table_name_at_db1 and schema1, with dba role and not explicit grants, executes the procedure stored on db2, i get no error. So i have to explicitly grant schema1 when it accesses schema2.table_name, i don't when it accesses schema2.table_name_at_db2 from db1.
Why? Received on Mon Sep 27 2004 - 12:04:55 CEST