• Article Type: General
• Product: Aleph
• Product Version: 3.0.0

Problem Symptoms:
When trying to run a report using Report Studio get an error message "User defined SQL is not permitted for the user who has the identity {All Authenticated Users, Everyone, Query Users, Consumers, Metrics Authors, Metrics Users, Planning Users, Controller Users, Analysis Users, Data Manager Authors, EDP Portal Admin}'. DPR-ERR-2082 An error has occurred. Please contact your administrator. The complete error has been logged by CAF with SecureErrorID: date

Cause:
Permissions for "User Defined SQL" capability is not sufficient

Resolution:
Change capability permission.
1. From within the Cognos connection page, navigate to Cognos Administration -> Security tab -> Capabilities.
2. Click on the arrow to the right of Report Studio. a drop down menu will appear.
3. select Set properties. On the screen the comes up select the Permissions tab.
4. Add the Controller Users group to the list and grant the group traverse privileges.
5. Click OK to commit the changes.

Allowing Controller Users to run User Defined SQL:
1. Still under the capabilities window under Cognos Administration -> Security tab ->
2. Click on Report Studio. This will reveal the items below it.
3. Click on the arrow to the right of User Defined SQL. A drop down menu will appear.
4. On the screen the comes up select the Permissions tab.
5. Add the Controller Users group and grant them Read and Execute rights.

Category: ARC Configuration

• Article last edited: 10/8/2013