PermissionGrants
Displays all permission grants defined in permission schemes, including scope and associated roles or groups.
Select
Retrieves permission grants defined in Jira permission schemes.
The add-in uses the Jira REST API to process filters based on PermissionSchemeId, with or without the Id of the permission grant. Other filters are processed client-side by the add-in.
For best performance, PermissionSchemeId should be specified to retrieve results. If it is not provided, the add-in will query the PermissionSchemes table to obtain the relevant scheme identifiers and then use them to fetch the corresponding permission grants.
For example, the following query is processed server side:
SELECT * FROM PermissionGrants WHERE PermissionSchemeId = '10216' SELECT * FROM PermissionGrants WHERE PermissionSchemeId = '10216' AND Id = '13406'
Insert
Creates a permission grant in a permission scheme.
To add a new permission grant, you must provide at least the PermissionSchemeId, the permission to assign, and the holder properties: HolderType and one of the following, depending on the Jira platform:
- Jira Cloud: HolderParameter or HolderValue
- Jira Server: HolderParameter
INSERT INTO PermissionGrants (PermissionSchemeId, Permission, HolderType, HolderParameter) VALUES('10216', 'WORK_ON_ISSUES', 'group', 'engineering-team')
INSERT INTO PermissionGrants (PermissionSchemeId, Permission, HolderType, HolderValue) VALUES('10216', 'WORK_ON_ISSUES', 'group', '6d595024-bfed-4d89-8faa-7068649103c5')
Delete
Deletes a permission grant from a permission scheme.
To remove a permission grant, you must specify both PermissionSchemeId and Id.
DELETE PermissionGrants WHERE PermissionSchemeId = '10000' AND Id = '10500'
Columns
| Name | Type | ReadOnly | References | SupportedOperators | Platform | Description |
| PermissionSchemeId [KEY] | String | False | = | Common |
The unique identifier of the permission scheme that contains the granted permission. | |
| Id [KEY] | String | True | = | Common |
The unique identifier for the specific permission grant entry. | |
| Permission | String | False |
Permissions.Key | Common |
The specific Jira permission that is being granted, such as 'Browse Projects' or 'Edit Issues'. | |
| HolderParameter | String | False | Common |
A value that identifies the permission holder. This can be a group name, project role, or user identifier, depending on the holder type. | ||
| HolderType | String | False | Common |
The category of entity receiving the permission. This could be a user, group, project role, or other valid Jira permission holder. | ||
| HolderValue | String | False | Cloud |
The identifier used by Jira to apply the permission to the selected holder type, for example a group name or project role ID. |