Forum Stats

  • 3,837,266 Users
  • 2,262,245 Discussions
  • 7,900,242 Comments

Discussions

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

ANNEC
ANNEC Member Posts: 316 Bronze Badge

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,

Answers