Home > Forum > Database > report permission

report permission
0

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

MVP

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

Did you know that with WEBCON you can automate virtually any process? Even baking cookies 🍪
 
Speaking of cookies: we use the ones that are essential for our website to function properly, as well as additional ones that help us customize our content to your preferences. If you don’t mind cookies, click Accept. If you want to learn more, explore settings.
Settings