Cognos 8.2的Report Studio中使用自定义SQL作报表发布,当其他人执行报表时报错信息如下:
RQP-DEF-0326
User defined SQL is not permitted for the user who has the identity '{All Authenticated Users, Everyone, Query Users, Consumers, Planning Contributor Users}'.
Details :
DPR-ERR-2082 An error has occurred. Please contact your administrator. The complete error has been logged by CAF with SecureErrorID:2009-02-11-09:27:26.671-#1
数据源的权限是Every one都可以执行
请教如何解决此问题?
------解决方案--------------------
这是查看报表的用户没有执行手写SQL的权限,用管理员身份进入Cognos Connection->Tools->function and Capability->Report Studio->SQL,属性-权限列表中加入查看报表的用户