03.04.2024
14:40
Hi
is there a way to get from the database all the permissions to all the reports that we have ? I was not able to find any column with that information and I do not know how to get such info
03.04.2024
22:50
Hi, it should be possible - based on schema documentation* there are two tables that should do the job:
* WFConfigurationSecurities - this contains information about who have privileges
* AppReports - this contains list of the reports
There is a key between those tables, so you can join them on ARP_ID = CSC_ARPID.
On WFConfigurationSecurities you will find CSC_UserLoginName and CSC_UserName.
Those could be later joined with CacheOrganizationStructure to get more informations on users based on AD/AAD (join on login)
* https://developer.webcon.com/2023/resources/db/?PageSpeed=off#AppReports
* https://developer.webcon.com/2023/resources/db/?PageSpeed=off#WFConfigurationSecurities
* https://developer.webcon.com/2023/resources/db/?PageSpeed=off#CacheOrganizationStructure
