Bamboo database schema: plan permission

[David_Ren]

Hi all, do you know which table is related to the plan permission of each user in the plan. The plan permission can be find through plan configuration-> permission. But i search through the database and the https://confluence.atlassian.com/display/BAMKB/Bamboo+5.7.2+Database+Schema. Wait for your reply!

[dericleeyy · Accepted solution]

The permission configuration is stored in the acl_entry table

The username is found in column SID, mask represents the permission level and ACL_OBJECT_IDENTITY reference a row in table acl_object_identity.

In table acl_object_identity, the object_id_identity column refers to the build plan ID which can be found in table build

[David_Ren]

Thanks very much! Without your hint I think it will be very very complicated to find the relation.

[David_Ren]

I think the document and knowledge base is far less detailed of bamboo than jira on atlassian.