user written SQL

[cognosfreelancer]

Folks

When my client runs a report developed in Report Studio with handwritten SQL she gets an error 'user defined SQL is not permitted'.

Short of doing the following:

- granting her permission to use the Report Studio capability
- using a view in place of the hand written SQL either in the database or FM model

how can I get her to run the report successfully.

Thanks
NKT

[Merri]

I think those are the only options you have. It would be worrying if you could get around the security that easily!

You could always get her to send you the SQL (assuming you have permission to run user-defined SQL), so you can run it for her.

[BIsrik]

share with us how you enabled that security feature. I too have the same probs and tried all the options but all in vien.

[Draoued]

If you give the Report Studio to your customer, it means that the Report Studio icon will appear in the upper-right corner, so she will be able to develop her own report in report studio. I m not sure if this is the option you want.
And a new report studio user means 1 report Studio Licence.

There is another way:
In Cognos Connection , go to Tools/Capabilities
Click Report Studio
and open the properties of User Defined SQL, here you can grant execute permission to any user-class or to another role, like for example Consumer.
If you grant "User Defined SQL" to the Consumer role, it would mean that any body allowed to execute reports, can execute it even if it contains hand written SQL. And they will not have the Report Studio component available.


I would recommend that you do the same for HTML Items in Report otherwise any javascript or HTML tags added to the report will not work.


Hope it helps.

[cognosfreelancer]

Draoued

Exactly what I needed. Thanks a bunch.

So simple I feel so stupid. ;D

[Merri]

Well done, Draoued. Great explanation of how to grant the capability.

In my answer, I assumed you knew that this was a separately-grantable capability, that she already had Report Studio, and you didn't want to grant her the extra functionality.

There are a few other separately securable functions - HTML, as Draoued noted, and bursting, as well as create/delete. The Admin & Security Guide explains them all.