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.