Hi,
I'm logged to the database as userA with quite wide privileges, and creating a view for userB using the SQL Window:
create or replace view userB.test_view as
select id
from test_table;
Assuming test_table is owned by userB this view could be compiled successfully. But, when right-clicking on the "test_table" (no mater before or after compilation) PL/SQL developer doesn't recognise the test_table as the database object. It only changes if I change the code to:
create or replace view userB.test_view as
select id
from userB.test_table;
Could you fix it?
