mc.bechara Posted March 26, 2015 Share Posted March 26, 2015 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? Link to comment Share on other sites More sharing options...
elizam Posted March 26, 2015 Share Posted March 26, 2015 Try adding execute permission on the datasource and ad hocs. Link to comment Share on other sites More sharing options...
marianol Posted March 26, 2015 Share Posted March 26, 2015 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now