I have been working with the DBA and we have made some progress. He added a DB with the same name as the USER. That allowed the 'Choose Database' drop down to fill in and I was able to choose the DB and connect. But, that is it. There is nothing else associated to the connection, like tables, views, etc. The only thing I can do is run a SQL statement.
This error is because the user you are trying to use does not have enough privileges on the PG side.
You should use the psql command line utility to test that your username ('psql -U user -W') is able to connect and see the database and tables that you want, and then use the same for the SQLDeveloper.
The user does have appropriate permissions. When I connect via ODBC using WinSQL, using the same user. I can see tables, views, etc and run SQL. Also, the WinSQL connection did not require that a dummy DB be created named the same as the USER. Oracle SQL Developer is a nice tool and I use it for mostly Oracle development and a little SQL Server. Sure wish GP would function better.
Well, what is happening is that SQL Developer uses INFORMATION_SCHEMA.* views to show information, and those views filter out information about objects that the user doesn't have any privileges for. While on the other hand, the PG catalog (pg_* views) will show you all information regarding your privileges, and those are probably used by your windows utility (it is the classical approach, also).
You can validate this granting the owner of the database to the connection user. It is not enough to grant CONNECT or "ALL PRIVILEGES ON DATABASE", you need to grant a role who owns the database you want to use (PG roles are users).
But this is a bit off-topic, it is a Postgres privilege issue, you can find a lot more information on PG forums.
For example, the discussion about how INFORMATION_SCHEMA views filters information: Privileges for INFORMATION_SCHEMA.SCHEMATA (was Re: Small clarification in &quot;34.41. schemata&quot;)