I am trying to find a solution for a specific use case:
We connect to Redshift datasources via tableau using a system account that is embedded in the data sources. We would like to connect to Redshift using different credentials, depending on the tableau user's login.
Conceptually, looking to execute something like this:
IF USERNAME()='this' THEN <connect to ds using account X>
ELSE <connect to datasource using account Y>
Is there a way to manage this in tableau without making 2 different copies of the datasource?
@Mike Lederer got it. The idea behind RLS is that is reading the Username() from the Tableau Server under which the user is recognized.
Data base credentials - in this case can be one used in the connector.
Can you UNION all - and place 2 views in 1 data source? After, you might use RLS on the dashboard side to map based on the user login.
Thanks,
Adrian Zinovei - Tableau Forum Ambassador
