Shared Table Definitions?

ray.wurlod · Post by **ray.wurlod** » Sat Feb 15, 2014 5:16 am

"Table or view not found" is nothing at all to do with the table definitions. It is about incorrectly qualified table/view names, possibly caused by the table or view not being in the connecting user's default schema.

iq_etl · Post by **iq_etl** » Mon Feb 17, 2014 8:30 am

Thanks for clarifying that this is unrelated to table definitions.

I'm still confused as to what is going on. The two tables are in the same schema that as the other tables used in this job. Again, I can see these tables and their data in the correct schema in SQL developer, I can even load the columns from this table, but the data isn't found.

Could it be permissions or grants on these specific tables preventing our production project from viewing the data? How can I correct that?

chulett · Post by **chulett** » Mon Feb 17, 2014 8:42 am

Yes, it could be and that would be an issue to raise with your DBA.

iq_etl · Post by **iq_etl** » Mon Feb 17, 2014 9:46 am

Our DBA applied the appropriate grants and now all is well.
(It's possible the grants script wasn't initially run or perhaps not successful)

Thanks all!