帆软报表V11升级最新版本后部分报表报错

微信截图_20231220175659.png 升级版本后部分报表报错，数据库是mssql2012，脚本在Microsoft SQL Server Management Studio里可运行。

FineReport bobo2468 发布于 2023-12-20 17:58

1min目标场景问卷

立即参与

回答问题关注问题

悬赏：3 F币 + 添加悬赏

提示：增加悬赏、完善问题、追问等操作，可使您的问题被置顶，并向所有关注者发送通知

共2回答

最佳回答

ColdmanLv6高级互助
发布于2024-9-21 10:35

11.0.28 升级了安全策略，禁用了部分有风险的SQL关键词，可参考填报修改fine_conf_entity，新增以下两项，重启项目后生效：

id:

JDBCSecurityConfiguration.sqlWhiteKeyword

value:

["attach","create","drop","truncate","benchmark","alter","xp_dirtree","comment","merge","insert","update","delete","call","rename","lock","exec","database"]

id:

JDBCSecurityConfiguration.sqlBlackFunction

value:

["attach","create","drop","truncate","benchmark","alter","xp_dirtree","comment","merge","insert","update","delete","call","rename","lock","exec","database"]

fr11小版本升级后报错DDL/DMLqueryisnotpermittedforcur - 我的帆软 (fanruan.com)