Enabling Authors group permissions
By default, the Authors InForm Reporting group restricts users from including HTML items and user-defined SQL when creating reports.
For on-premises customers in a self-hosted environment, these default permissions can be modified to remove these restrictions in the Cognos Administration module:
- Login as a Cognos system administrator.
- Go to Manage > People > Capabilities.
A search box appears.
- Search for and select Edit User Defined SQL permission.
- Open the menu and click Customize Access.
- Remove the All Authenticated Users group by clicking the minus (-) button. Confirm the deletion.
- Add the Authors group to Edit User Defined SQL permission by clicking the plus (+) button.
- Click Cognos.
- Search for and select the Authors group.
- Click the plus (+) button to assign the Access permission to the group.
- Repeat steps 3 to 6 to add the Authors group to the Edit HTML Items permission.
All users belonging to the Authors group will now be able to make changes to user-defined SQL and HTML items.
Note: If implemented, this customization should be re-assessed for potential impact following any version upgrade for IBM Cognos Analytics, and dependent on future changes in the Cognos security or permissions model, may require to be re-applied or revised. For more information,, please see the IBM Cognos Analytics documentation.