This content has been marked as final. Show 2 replies
You have privileges to select from the view but not the underlying table. This is a fairly common security scheme. You will have to get the table owner ('s dba) to give you privileges directly on the underlying table if you have a business need to directly access it.
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.
allows you to select from the view but doesn't allow you to access (or even see) the underlying table(s) of the view.
This is a security mechanism - for example there might be columns (like salary) that the owner doesn't want you to see,
so they exclude them from the view.
If you want to access the table you must get the owner to grant you access to it.