COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: RP on 06 Jan 2009 04:34:31 PM

Title: Error on report studio
Post by: RP on 06 Jan 2009 04:34:31 PM
Hi,

can any one help me, When I try to open reports, I get the following error

"User defined SQL is not permitted for the user who has the identity '{All Authenticated Users, Everyone, Consumers, Planning Contributor Users, Controller Users, Analysis Users, Data Manager Authors, CRM, BI Business Analysts, Campaign Management}'."

Looks like there is some issue in the privileges or anyathing else?

Thanks
RP
Title: Re: Error on report studio
Post by: someonear on 08 Jan 2009 02:24:07 PM
Go to Tools > Capability > Report Studio > Properties of User Defined SQL  > Permissions and modify security settings