The ODBC connection error is displayed when The Toad Data Point is connected to the PostgreSQL database via ODBC driver. Because of security reasons, the access to the pg_catalog schema is revoked.
On SQL Developer everything works fine.
In PostgreSQL log can be found errors like this:
[unknown] ERROR: permission denied for schema pg_catalog at character 33
13 42501: 2017-02-01 12:56:33 GMT : [4-1] user = xxxx,db = xxxx,remote = xxx.xxx.xxx.xxx(xxxxx) app = [unknown]
STATEMEN T: select NULL, nspname, NULL from pg_catalog.pg_namespace n where true and nspname not in ('pg_catalog', 'information_sch ema', 'pg_toast', 'pg_temp_1') order by nspname
ODBC driver uses pg_catalog schema for gathering information about the database.
SQL Developer uses JDBC connector. JDBC connector uses information_schema schema for a gathering of information about the database.
- Allow usage of the pg_schema to the concrete user.
- Download the source code of the ODBC driver, change SQL queries used in the ODBC driver to use INFORMATION_SCHEMA schema and compile the driver.