I am a little confused about your question. There is one content owner, bu you said above that you want to restrict multiple users from downloading underlying data. Can you please clarify this a bit more?
Also, are you trying to restrict the full data from the actual content owner?
If so, this seems a bit odd since they would have had access to it when they built the workbook.
1 of 1 people found this helpful
Hi Zaheer -
As Jennifer mentioned, this request is a bit out of the ordinary - generally the content owner will be the same person who initially created the workbook (and therefore had complete permissions on the data to begin with).
Sometimes ownership will be changed post-publish, however. Or the "open analytic" culture hasn't caught on strongly enough. Anyway, if this is a requirement, you can find the information, but it takes some heavy lifting on your part.
The query below is something I put together for a different customer who had the same question. It is unsupported and it relies on certain flags in the system tables that could change in the future. Use at your own risk
In essence, it looks for looks for someone doing a "View Data" and then rendering the information to a csv file - which is what happens when you download the data in question. This query should give you a good feel for the tables and flags in question, and you can take if from there.
r.user_id as "User ID - Site",
u.system_user_id as "User ID - System",
su.name as "User Name",
su.friendly_name as "Friendly Name",
vd.vizql_session = r.vizql_session
r.site_id = u.site_id AND r.user_id = u.id
u.system_user_id = su.id
r.action = 'show' AND -- Begin Rendering
vd.action = 'vud' AND -- View Data
vd.http_request_uri like '%csv=true%' – View Data AND Download it
Thank you for providing the solution that seems fulfill our monitoring data download request but with the caution of any future changes. That mean we will have to be careful when upgrading Tableau Server.
I agree with Jennifer and you that the requirement is bit odd but we have to comply with the data governance rules.
Again, I would highly appreciate you for resolving our problem.