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 connector 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 connector.
For best performance, PermissionSchemeId should be specified to retrieve results. If it is not provided, the connector 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. |