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
16388
Joined: Sep 13 2011 - 8:04am
Last seen: 4 years 8 months ago
Feedback
randomness