KNOWLEDGE BASE

Limit the Schemas That Can Be Selected When Connecting to Data Sources


Published: 02 Nov 2021
Last Modified Date: 04 Nov 2021

Question

When connecting to databases using a user ID, all the schemas that the user has access to could be selected.
How can I set restrictions of schema when connecting to databases like Oracle?

Environment

  • Tableau Prep Builder
  • Tableau Desktop

Answer

The ability to set restrictions of schema when connecting to databases is not currently built into the Tableau product.
Please consider the following workarounds:

Option 1:
Set restrictions on the database side.
Please ask the database administrator for help.

Option 2:
Publish the data from the database to Tableau Server (Or Tableau Online) and set Permissions when publishing the data source. 
This way, the access permissions to the data source could be managed on the Tableau server side. 

Please check the below online help for details:
Set Permissions as You Publish a Data Source or Workbook
Did this article resolve the issue?