Bamboo database schema: plan permission

David_Ren April 12, 2015

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!

1 answer

1 accepted

1 vote
Answer accepted
dericleeyy April 13, 2015

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 April 15, 2015

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

David_Ren April 15, 2015

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events