This content has been marked as final. Show 2 replies
What privileges etc does an Oracle user account have to have to be able to load Tables, Views etc in the Connections tree?
I have an admin user account which loads all objetcs and a read-only user account which cannot load any.
I would prefer to use the Read-Only account for day-to-day querying etc, but still want it to be able to load objects into the tree.
You didn't say what the point was in seeing things that you can't do anything with but try this
Then use the 'Other Users' part of the tree to examine objects
create user read_only_user identified by read_only_user grant create session to read_only_user grant select any dictionary to read_only_user
That is all you need in 11g.
We had done part of that (grant select any dictionary to read_only_user), but I had forgotten about the 'Other Users' tree node (even though i now recall having used it some years ago)