Description

When you try to create joins in Query, you will get the following message:
Information Message: You do not have privileges to create joins in a query as per Admin settings

Applies To

Query, Connect, Central, User Governance

Solution

Note: Please ensure your license type in order to resolve this issue.

Connect license users:

Click Tools > Options > Admin Defaults.
You will be prompted to enter a password. The default Query password is queryshuttleadmin.

Note : If you are not able to access the Admin Defaults tab, exit from the Query and then try opening it by
right-clicking the Query shortcut icon and select Run as administrator .
Check the boxes for both the Enable Creation of Joins in Querybuilder option and the Enable Joins for
Transparent, Cluster, View and Pool Tables option .

Winshuttle Central Users (10.x)

If you are using a Winshuttle Central 10.x, these options are set by your Central site administrator.
Navigate to your Central site. Navigate to Winshuttle Central administration > Query > Developer Proficiency level settings .
In here, check the boxes for both the Enable Creation of Joins in Querybuilder option and
Enable Joins for Transparent, Cluster, View and Pool Tables option.

Winshuttle User Governance Users (11.x)

If you are using User Governance 11.x (previously called as Central), these options are set by your Central Application Administrator.
Navigate to your Foundation User Governance site. Navigate to Settings> Developer Proficiency level settings .
In here, check the boxes for both the Enable Creation of Joins in Querybuilder option and
Enable Joins for Transparent, Cluster, View and Pool Tables option .






Note: Developer proficiency levels are respected properly.
Query script developer capabilities are being determined according to their query proficiency level set in User Governance User Profile.
If 'advanced' query proficiency level is defined for a user then its query script creation capabilities are being determined using settings under 'advanced' developer proficiency level section in Foundation.