We are trying to restrict User from editing or creating the SQL based queries to the Report Studio. Example, we developed some custom SQL queries for reporting, this works
well with the Query Studio and Consumer Users without any issue, because they don't have access to Report Studio. The only problem is with Report Studio access users who can get in to Report Studio and able to edit the SQL based queries and they will be to create their own reports. If I change the User Defined SQL capabilities to RS users they will not be able to run already developed reports. I appreciate your help. Thanks
If you give only Traverse rights to the user defined sql they should be able to execute reports with custom sql, yet still not edit custom sql.