...
Let's say you have an application data source already defined in server.xml (as shown in screenshot below), for which you want to implement this role based security. Follow the steps below:
- Go to UPM and find the SQL for Confluence add-on (Manage add-ons).
- Click the Configure button.
- To add a role based security datasource, use dataSource parameter. Refer to the screenshot below:
The new profile (in this case "rolebased") is available immediately. Test it on a page to ensure expected behavior.
...
Since select on "cwd_group" table is granted to bob, only the respective data is visible but not "cwd_user" table data.
- If any other user (lets say random user who has no database role associated to thier own account/userid) tries to access the page:
Since there is no role associated with this user, an error message will be shown.