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.
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
Hey there, Sameera.
Perhaps you can check on the following documentation. You might be able to find what you are looking for:
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events