Tables are not shown in Oracle SQL Developer

Question

I have several connections configured on TNSNAMES.ORA, and for some I cannot see any table if I expand the folder.
The user I am connecting has access, because I do the queries and insertions normally.

I found on the internet a tip to enable the filter option "Include synonyms", but it did not work.

I ran a test with PL/SQL Developer allroundautomations and in it the tables appear normally, but the tool is trial for 30 days.

As in this second tool the tables appear, I believe it is not some limitation of the user I use to connect me, but I noticed the following difference in TNSNAMES.ORA: my strings that show the table use SERVICE_NAME while the ones that don’t show tabelam use SID.

String example showing the tables:

BDTESTE = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = TCP)(HOST = serv01)(PORT = 12345))
    )
    (CONNECT_DATA = 
      (SID = BDTESTE)
    )
  )

String example that does not show tables:

BDTESTE2 = 
  (DESCRIPTION =
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.200)(PORT = 12346))
    )
    (CONNECT_DATA = 
      (SERVICE_NAME = bdteste2.xyz.com.br)
    )
  )

Answer 1

I got a way to access all the tables and the rest of the objects I couldn’t see. The user I’m logging in is associated with the 'x' scheme that views few BD objects, but has access to other objects that by some access limitation is visible only in the 'y' scheme. So all I had to do was locate the schematic by doing the following:

1. Right click on the connection;
2. Find BD object;
3. Expand 'All Schemes';
4. Select the schema with access to view all objects and click Go;

This way I can view and edit all BD objects, but unfortunately I did not find a way to show them directly in the connection panel.

Answer 2

Remove all the filters you will be able to view all the tables in that box.