I've created an enterprise geodatabase on Oracle. I can connect to it from ArcCatalog and from SQL Developer using the SDE user.
I've created a new user named GFPTest using the Create Database User tool, choosing the defaults for Role and Tablespace Name.
I can connect to the database in ArcCatalog using the GFPTest user. However, when I connect in SQL Developer using the GFPTest user, I can't see any tables.
Is there something in creating the database user that I've missed?