I am looking for custom query which gives the result of roles and its capabilities
|Interactor||Download the workbook||yes|
|viewer||Download the workbook||Null|
as we know viewer doesn't have the capability to download work i need to show a row along with status as null
Any one help me with what tables to join to get the desired output
Permissions are a difficult thing to get from the Tableau Server; it's not as simple as we think I've yet to see someone get this where it's fast and accurate...oh, plus it's already changed at least once as well as depreciating once-useful fields (Re: Tableau Workgroup Database update in 10.5 ).