I am using oracle sql developer desktop version.
We have created a hr_readonly user for only can select tables.
I can select * from schools, can also select * from hr.schools.
But the main schema is hr.
When I login using hr_readonly account, I can query using select from tables.
But I cannot see the tables show in the left panel under tables. Is that normal, of course I can click other users tab, and find hr user, and see tables listed under hr.
I thought since hr_readonly have read access, it should list all those tables under its own name.
Thanks,