Open Postgres table error in Enterprise Guide

[parth_patel]

Hi,

I have created Postgres library in SMC and already registered some tables. When I am trying to open those tables in DI it's opening but when I am trying to open in EG it is giving me an error shown in attached screen shot. According to error message I checked table and db user permission and set it to superuser, but still facing the same issue.

Kindly request to help me resolving the issue. Thanks in advance.

Regards,

Parth Patel

[BrunoMueller · Accepted solution]

Hi Parth

You need to set the "Read" permission in the SMC on the table object, or better on the folder containing the table object.

The Enterprise Guide is using the META Libname Engine and therefore enforcing metadata permissions.

Bruno