setting role permission to a folder of reports but still access denied

I have a folder REPORTS containing all reports created from adhoc views. Another folder datasources containing the datasource.

Another folder containing the adhoc reports. But I was to give access to  user "R" to see only the REPORTS folder. 

so I created role_reports and on REports folder put permission of this role to "administer", and on the "Datasources" and "Ad hoc reports" permission no access.

I then went inside datasources folder and selected the datasource and gave permission "Read-only" Same for the ad hoc reports folder, I selected the adhocs related to the reports and gave permission "Read-only"

But still after logging to user "R", I see the "Reports" folder and when I try to click on a report it opens and gives me access denied. What am i missing?

mc.bechara's picture
Joined: Jul 7 2014 - 4:39am
Last seen: 7 years 8 months ago

Try adding execute permission on the datasource and ad hocs.

elizam - 8 years 2 months ago

1 Answer:

Instead of no_access give them execute_only permission on the datasources, they will have no access to them, but the reports they have access will be able to execute queries to those datasources.

marianol's picture
Joined: Sep 13 2011 - 8:04am
Last seen: 4 years 8 months ago