882134 wrote:That's normal Oracle behaviour. The owner of a table can create a view and grant select access on the view to you which
I have an issue. I am able to access one table (in different schema) from view but cann't access table directly. view script is like this
column1,column2, column3 as (select c1,c2,c3 from table1)
when i tried to access table1 directly getting error "Object table1 not exists" but I am accessing this table from view.
even I tried to findout the table/view name from all_tables / all_views system view.
But 0there is no such table/view esists. Also verified synonyms. Pleae help me how to find
the object, where (schema) it is exists.