If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Restrict Users from Creating own SQL queries in Report Studio.

Started by kilaru2772, 22 Mar 2012 03:28:19 PM

Previous topic - Next topic

kilaru2772

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

tjohnson3050

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.