In Toad, I can browse all database objects across schemas—even those I don’t own or have direct grants on. It appears to use DBA_OBJECTS or similar views internally, and shows everything I can access, even if the access is granted via a role.
In SQL Developer, I can only see objects I own or have direct or role-based grants on. Even though my user has access to DBA_OBJECTS and DBA_SOURCE via a role, SQL Developer doesn’t show those objects in the Connections tree or Schema Browser.
Is there a way to configure SQL Developer to use DBA_* views for object browsing, similar to how Toad does it? I’m not looking to grant SELECT ANY DICTIONARY—just want SQL Developer to recognize and use the views I already have access to.
Any help or insight would be appreciated!