I want to hide the capability of adding SQL queries in Report Studio to certain authors. But i want them to be able to run the reports with SQL queries. These authors I am talking about have access to report studio. I just don't want them to be able to add SQL queries. How do I do that ?
TIA.
you can deny the capability to that role.
There is a run report option in properties > advanced > run with owner capabilities.
If the owner of the report has a role with capabilities for nativeSQL, any user with permissions on the report should be able to run the report.
The user has access to report studio. So he can open the report in report studio and modify it. I don't want this user to write any sql queries inside report studio.
Is there a way to disable SQL query option from the tools menu for this user ?
I know you could in v11, probably somewhat possible in v10 just wouldn't know how.
However, the issue with that is they could always copy and paste an existing nativeSQL query and modify that sql. If they have access to do that once they could just save it in their personal folder as something else. After that they would have free range to make any nativeSQL report they wanted.