KNOWLEDGE BASE

Error "permission denied for relation" When Connecting to Tableau Server Repository


Published: 11 Mar 2020
Last Modified Date: 11 Mar 2020

Issue

When connecting to a view in the Tableau Server repository using the "tableau" user, the following error may occur:

ERROR: permission denied for relation <table>;
Error while executing the query

 

Environment

  • Tableau Server
  • Tableau Desktop
  • PostgreSQL

Resolution

To troubleshoot this issue, enable access for the "readonly" user to the database, and connect the Tableau Server repository using the "readonly" user.

For instructions on enabling repository access, see this Help document.

Cause

The table specified in the error message may only be available to the "readonly" user.
Did this article resolve the issue?