When trying to complete an action an error is displayed and contains the following message:
Error occurred while validating query syntax on [COMPONENT].
User 'USERNAME' does not have the required permission to ...
This message requires one or more of the following role(s):
The error message provides information to identify the component, the user and the permission(s) needed to complete the action.
This article contains more information on how to identify the role(s) missing and resolve the error.
The error message contains the component on which we will need to find the user.
Open the component (in this example a Broker) and go to Security > Users.
We should be able to identify the user and the role(s) needed. Click on the username (in this example 'test') and confirm which Role Memberships is selected for this user.
In this example the user 'test' was missing the role "Operators" which contains the Role Permission "sdk.manage" mentioned in the error message.
It will be possible to resolve the issue adding the necessary Role Membership to the user.
Please note that it may be needed to delete and re-add data sources and restart some services to force a refresh of the user role. In this example it was needed to delete and re-add the data sources on the Broker.