Page Comparison

This article shows you how to restrict the SQL Datasource datasource profile (in the SQL for Confluence app) to a specific user or a group.

Instructions

1. Create a Confluence page that contains an SQL macro with a Datasource datasource profile. Here in the below screenshot, the datasource configured is AuroraDB. :
   Image Removed
2. To know more about the SQL macro configurations, browse to the link SQL Macro is configured.
3. Image Added
   

   
   

4. Apply the restriction, 'Can view and edit'  to particular the users and groups based on the requirement. 
   Image Removedwhom you want the restriction of the profile.  
   Image Added
   
   
5. Navigate to General Configurations > BOB SWIFT CONFIGURATION > Macro Security to apply the restrictions to the datasource.
6. Configure similar restrictions to the dataSource profile in Macro Security under Secured Macro by adding sql.datasource in the macro name. 
   Image RemovedImage Added
7. Once the restrictions are applied, users who are part of the restrictions will not only be able to view the SQL macro content.
   Image Removed
   Image RemovedThe other restricted users will see the below error message on the Confluence page.
   
   Image Added
   
   Image Added