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; } } }

SQL: How to query JIRA's permission schemes

Sameera Shaakun2

JIRA's SCHEMEPERMISSIONS table consists of the following columns.

ID, SCHEME, PERMISSION, PERM_TYPE, PERM_PARAMETER

To where should I join PERMISSION column?

I couldn't find any table containing the set of permission types.

Thanks!

Shaakunthala

Accepted answers

Daniel Luevano_ezwo3t

You can use this query (PostgreSQL):

SELECT PS.name AS PermissionSchemeName,SP.perm_parameter AS GroupName, SP.permission_key AS Permission

FROM schemepermissions SP

INNER JOIN permissionscheme PS ON SP.scheme = PS.id

ORDER BY 1, 2, 3;

All comments

AhmadDanial

Hey there, Sameera.

Perhaps you can check on the following documentation. You might be able to find what you are looking for:

https://confluence.atlassian.com/display/JIRACOM/Example+SQL+queries+for+JIRA

Warm regards,

Danial

Sameera Shaakun2

Looking at the following Javadoc, I think this is not something we can query using SQL.

http://docs.atlassian.com/jira/latest/com/atlassian/jira/security/Permissions.html

Sameera Shaakun2

I forgot to add a justification to what I said above.

According to the Javadoc provided, all the permission items are actually integer constants. They seem to be hardcoded into JIRA so it is not possible to retrieve that information using SQL.

Leigh Simpson1

These are hardcoded constants within the JIRA codebase (see https://docs.atlassian.com/jira/latest/com/atlassian/jira/permission/Permission.html for Javadoc details of the `Permission` ENUM). There is a full list here: https://docs.atlassian.com/jira/latest/constant-values.html#com.atlassian.jira.security.Permissions.ADMINISTER

Daniel Luevano_ezwo3t

You can use this query (PostgreSQL):

SELECT PS.name AS PermissionSchemeName,SP.perm_parameter AS GroupName, SP.permission_key AS Permission

FROM schemepermissions SP

INNER JOIN permissionscheme PS ON SP.scheme = PS.id

ORDER BY 1, 2, 3;

Cody Crandall

This should be the top answer. Thanks Daniel!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

sql

jira

permission

database

permission-scheme