[Solved] Modifying permissions of system roles from DB

Added by Herberts Markuns over 7 years ago

Hi,
I'm building some integration with Redmine, and for that I need to modify default permissions of system roles, to basically allow anonymous and non member users to create issues and add notes.
I want to do that through the Redmine database, as a large part of integration already uses it.
However, I can't seem to find the table that contains such permissions, so I'm stuck in the implementation.
Does anyone has any knowledge on this? Thanks.

Replies (1)

RE: Modifying permissions of system roles from DB - Added by Herberts Markuns over 7 years ago

albfan on IRC helped me get to the answer.

The table I was looking for was "roles" and the column "permissions", which had content collapsed and thus appearing as having nothing, but actually includes permissions in the format of:

---
- :view_issues
- :add_issues
- :add_issue_notes

However,

[16:00] <albfan[m]> I discourage you to touch there directly

(1-1/1)

Project

General

Profile

Redmine