Finding 'Extended project administration' permissions in Jira Database.
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
The Extended Project Permission resides in a separate table from the main permissions table, scheme permission. This can make it tricky to find this in the database if you do not know where to search.
Cause
The 'Extended Project Administration' information is stored in the permissionschemeattribute table and not the schemepermissions table.
Solution
By default 'Extended Project Permission' is enabled and the database table 'permissionschemeattribute' is empty. This is by design and this table is only populated when this permission is disabled for the first time.
When you remove the 'Extended Project Administration' from that table, a new entry is added.
1
2
3
id scheme attribute_key attribute_value
----- ------ ------------------------------------ ---------------
10001 10000 ADMINISTER_PROJECTS.extended.enabled false If you re-enable 'Extended Project Administration', the attribute_value is modified to true.
1
2
3
id scheme attribute_key attribute_value
----- ------ ------------------------------------ ---------------
10001 10000 ADMINISTER_PROJECTS.extended.enabled true đź’ˇ The 'scheme' in the permissionschemeattribute matches to the permissionscheme table and can be used to find out which permission schemes have this functionality disabled.
Was this helpful?