Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

will read only user for other schema see list of tables under its own table list

ANNECJul 19 2022

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,

This post has been answered by Jim Smith on Jul 20 2022
Jump to Answer
Comments
Post Details
Added on Jul 19 2022
1 comment
1,247 views