What security needed to see objects in Oracle for a read-only user?
On Oracle 19c in dev I can see all of the objects which makes sense because I have full privileges there.
In test and prod on the other hand, where I am a read-only user, I can only see tables and views.

Using Toad I can see everything but not in DataGrip or DBeaver. I do have access to DBA_SOURCE so I can query for the procedure name and the source code but would rather have it display in the tree if possible.
What do I need in order to have the missing objects display? Bonus points are given if this results in able to also see procedure text.
请先登录再写评论。
Jimgust Please also check that you have granted with 'select any dictionary' & 'select_catalog_role'
I was denied access to the two privileges but I was tentatively granted "DEBUG ANY PROCEDURE", awaiting approval from dba manager.
That privilege added PACKAGE, PACKAGE BODY, PROCEDURE, and TYPE to the results of sys.ALL_OBJECTS.
The only thing it lacks is the synonyms. I do have access to ALL_SYNONYMS but those details are not in ALL_OBJECTS.
Can I force the schema refresh to use ALL_SYNONYMS?
Edit: Created Issue https://youtrack.jetbrains.com/issue/DBE-13027
Turns out this is an issue with Oracle where ALL_OBJECTS doesn't contain private synonyms that were granted from another user.
https://support.oracle.com/knowledge/Oracle%20Database%20Products/2249527_1.html
I will create an issue to change the logic to a LEFT OUTER JOIN when capturing catalog details for synonyms.