Hi All,
Recently Tableau released their 10.5 version. We were earlier using the 10.2.1 version and had developed a few custom admin views on the same such as identifying specific user permissions (publisher/interactor) etc.
However, with the recent update in 10.5, there have been changes made to the Workgroup Database by Tableau.
The biggest change impacting my custom admin views was the removal of both "Publisher_tristate" and the "Admin level" fields in the Users Table since I had earlier used these fields along with "licensing_role_id" to identify the permissions correctly for all users on the server.
Can anyone provide an input on how I could re-build these views again?
Also, Tableau has now removed the "Unlicensed (can publish)" and "Viewer (Can publish)" permissions from the server. it would be great to know how the users assigned these permissions earlier in 10.2 would be identified in the workgroup database.
So far, I haven't been able to find any documentation to identify all the changes made to the tables (and how it maps to the older version) or the introduction of new set of values in some of the tables.
Can anyone provide some insights into these?
Thanks & Regards,
Crystal
Hello Matt,
Thank you for your help. Unfortunately. It doesn't help with what I want to achieve right now. We wanted to identify each user permission assigned in a site and the number of people with the respective permissions
I did have another use case built up to identify just the Admins and the non-admins. That is working fine.
I've just been playing around with the workgroup database recently. And so far, what I have found is this
There's a table called "Site_Roles". This needs to be joined with other tables as per requirement. In my case I did this with the "users", "site" and the "system_users" tables to get the full list.
If I just use the Name field from Site Roles table, it assigns a system administrator as a publisher. So I've had to use the admin level field from the "system_users" table and entered a condition ---> if admin_level=10 then "system admin" else Name (site roles)
This way, I've now been able to identify each of the site roles which we needed for our Internal purposes.
PS: Thanks for sharing the link to your workbook. Its giving me some new ideas that are worth reporting. Will probably have a lot of questions answered once I dive into it.
.
null : I hope this helps you as well? The challenge for us was that we moved from 10.2 to 10.5 and the site_roles table was introduced was in 10.3 from what I see in this report Tableau Public
