Does sql-file macro require Macro Security plugin?

[Sergey Svishchev]

sql-file macro is new in SQL plugin 6.0 (https://bobswift.atlassian.net/wiki/x/I4GAAg) and is said to "allow[s] accessing specifically authorized scripts stored on the Confluence server file system."

Does it require a separate purchase of Macro Security plugin?

[Bob Swift · Accepted solution]

No, it can be used without Macro Security for Confluence. Part of the advantage of the SQL-file Macro is that it's usage does not need to be controlled or controlled as tightly as general sql macros as the queries that can be run are completely controlled by the administor - basically a fixed list of specific queries. This enables some of the power of sql reporting even on systems that have more severe security restrictions or audit requirements.

[Sergey Svishchev]

Thanks.

But users can still add other two macros with arbitratry SQL -- how do I disable them and keep only sql-file macro enabled?

[Bob Swift]

Follow these instructions: How to securely run SQL queries without page edit restrictions