Cognos 8.2的Report Studio中使用自定义SQL作报表发布，当其他人执行报表时报错？
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,属性-权限列表中加入查看报表的用户