Cannot SELECT granted table inside package

Hello all,

I have a simple SELECT statement inside a package that accesses a table in another user's schema (SELECT * FROM usera.some_table). The package does not compile and the error message says that the identifier "usera.some_table" is unknown. I have been granted all on the said table and can issue the same command from SQL*Plus without any problem. It is only from the package where the issue comes up.

Any idea how I might fix this?

Thanks! Received on Thu Nov 09 2000 - 17:31:28 CST