...
| Info |
|---|
Please note that it is necessary for the DB user (the user which we configured for accessing database. Refer to confluence.cfg.xml file in the home directory to get this information) to have the create role permissions in the database/data source. |
Set up the data source for SQL
Let's say you have an application data source already defined in server.xml (as shown in the 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 apps).
- Click the Configure button.
- Select the View and modify data source profiles tab.
- Click Add profile. To add a role based security datasourcedata source, select the data source as required. Refer to the screenshot below:
...
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 let's say random user who has no database role associated to with their own account/userid) tries to access the page:
Since there is no role associated with this user, an error message will be shown.
