To see what workbooks a user has access to can be done by selecting the particular user after either one or all of the workbooks have been selected.:
Hope this helps!
Thanks for your response. With the link you provided, where does the Check Users Permission screen exist on the Tableau Server? I have looked through all the screens...but may be just missing it.
Select all of the workbooks, then choose Permissions. From here, the drop down menu will appear so that you can see which users have access/rights to which workbooks.
Do you know how we can do it directly in a custom report ?
When I create a custom report using the http://kb.tableausoftware.com/articles/knowledgebase/creating-custom-administrative-views tutorial I can only get the user that have been logged on the server and selected a workbook (using the link between the table _views_stats and _users)
What I would need is a list of user and a list of workbook related to them.
Can you tell me on which table I can do it ?
This is a great question, Corey, and I too would very much like to know how I can create a report of permissions by :
There's an open Idea at http://community.tableau.com/ideas/1681 that you may want to Vote Up on to get enhanced dashboard permissions views.
Tracey, is this possible yet?
This question leads directly to the more general proposition that there's a real need to be able to see who has which permissions to what content.
This is a surprisingly tricky situation to address, particularly since the final assignment of a particular permission's state to a given object for a specific user is dynamically resolved - it's not just a static datum.
Even if permissions assignment were static, i.e. encoded in data it would be nontrivial to resolve given the hierarchical, subtly complex relationships between license levels, publishing permissions, etc at the Site level and the Site/Project/Workbook/View structure, not to mention the complications Data Sources being into things.
Add to the structural elements inheritance, groups, and the permissions resolution algorithm it get really convoluted.
On top of which Tableau was designed to support flat record sets and doesn't embody any mechanisms for modeling or query even a simple two level master-detail hierarchy, much the multi-level, multi-path permissions structure.
Still, I've been working on trying to puzzle out a way to meet this need, and if my hunch is right it just might me a manageable problem, albeit not amenable within Tableau to a wholly satisfactory or elegant solution.
It is disappointing to realize that such a trivial question like listing all the users that belong to a group is impossible to answer using the default Tableau admin interface.
Cool visual, Aaron. If you still have it, would you mind exposing the joins to the Postgres tables used in your view? thanks.