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 - 05:04:55 CDT
