reports of each user : howto view

[xkorakidis]

Hi there,

I'm using the JasperServer 2.1.0.1 Linux with Bundled MySQL version (community edition).

I tried to discover how the reports are related to user roles => to users but didn't find anything. I noticed that the table JIObjectPermission is not connected with other tables like the JIResource.

Is that possible to make a SQL query which gives me the reports each user and their rights (view, modify etc) on those reports?

Furthermore, I noticed that there is a table namedJILogEvent which is empty. What is this table for? Is that possible to log the use of reports? It would be great if I could make a reports which shows what reports (with what parameters) each user has used last day (/week/month/year). Is that possible?

 

Thanks in advance!