Desktop productivity for business analysts and programmers

Open Postgres table error in Enterprise Guide

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

Open Postgres table error in Enterprise Guide

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

Attachment

Accepted Solutions
Solution
‎10-07-2015 03:49 AM
SAS Super FREQ
Posts: 676

Re: Open Postgres table error in Enterprise Guide

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

View solution in original post


All Replies
Solution
‎10-07-2015 03:49 AM
SAS Super FREQ
Posts: 676

Re: Open Postgres table error in Enterprise Guide

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

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 225 views
  • 1 like
  • 2 in conversation