Safer SQL for data aggregation
Data aggregation uses SQL in the Data aggregation properties BO to collect and calculate data.
To make this safer:
• A new setting will appear in System settings > Security > SQL validation:
◦ DAM SQL validation.
• If set to No (the default after upgrade):
◦ The existing basic protection stays in place (blocks DELETE, UPDATE, DROP).
• If set to Yes:
◦ The stricter protection currently used for self-service SQL is applied to DAM as well.
This is mainly relevant for admins and consultants, but as an end user it means:
• Your system is better protected against unsafe or incorrect SQL in DAM.
• Changes to DAM SQL will be tested against real customer examples to avoid breaking working setups.