nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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!

Accepted answers

dericleeyy

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

All comments

dericleeyy

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.