Overview:
This article describes in detail how to implement a role based security.
Step by step process:
Define roles in the database for a confluence user :
Use the following commands to create user,role and grant the privileges to the role.The commands work for PostgreSQL database. You may need to contact your DB administrator for the respective commands if you are using other database.
...
| 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 screenshot below), for which you want to implement this role based security. Follow the steps below:
...