Using custom SQL in Cognos requires the user to have access to the 'User defined SQL' capability. However it happens that users having this right nevertheless get an error when defining a SQL Query for a report.

ERROR

RQP-DEF-0326 User defined SQL is not permitted for the user who has the identity ... 


RESOLUTION

This happens if no package has been selected for your report. Even if a report is based on custom SQL, it needs to be associated to a package.

To do so, go to Data - Source and click the + symbol and then select a package, e.g. 'Changepoint' or 'Changepoint unsecured'.