My Oracle Support Banner

Unable to See Drop Down Tables in SQL Developer (Doc ID 2952070.1)

Last updated on JUNE 05, 2023

Applies to:

Oracle SQL Developer - Version 19.3 and later
Information in this document applies to any platform.

Symptoms

User <USER1> is unable to see drop-down table lists in SQL Developer. This is a user who does not own the object, but has the following grants and tables owned by <USER2> :

1) grant select_catalog_role to <USER1>;
2) grant select and view objects to <USER1>;


Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.