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 [4981]: [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
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center