The SQL File macro has parameters and behavior similar to the SQL macro. There are two primary reasons for using this macro:
- Security - it can be secured independently of the SQL and SQL attachment macros. If you are an administrator:
- You can control the queries accessible to the general users who are authorized using the Macro Security for Confluence app.
- If you are not using Macro Security for Confluence app, you can disable the SQL and SQL Query macros while allowing access to the SQL File macro. (As it allows users to query only a fixed set of statements.)
For more information on:
Example: Use SQL Macro with Markup