Displays all permission grants defined in permission schemes, including scope and associated roles or groups.

Table-Specific Information

SELECT

Retrieves permission grants defined in Jira permission schemes.

The add-in uses the Jira API to process filters based on the PermissionSchemeId and Id columns. The add-in processes all other filters client-side.

You must specify a PermissionSchemeId to retrieve results. If PermissionSchemeId is not specified, the add-in automatically queries the PermissionSchemes table to retrieve the relevant scheme identifiers. This may result in increased query times.

For example, the following queries are processed server-side:

SELECT * FROM PermissionGrants WHERE PermissionSchemeId = '10216';
SELECT * FROM PermissionGrants WHERE PermissionSchemeId = '10216' AND Id = '13406';

INSERT

Insert a permission grant in a permission scheme by specifying PermissionSchemeId, Permission, and the holder properties: HolderType and one of the following, depending on the Jira platform:

• Jira Cloud: HolderParameter or HolderValue
• Jira Data Center: 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

Delete a permission grant from a permission scheme by specifying PermissionSchemeId and Id.

DELETE FROM PermissionGrants WHERE PermissionSchemeId = '10000' AND Id = '10500';

Columns

Name	Type	ReadOnly	References	SupportedOperators	Platform	Description
PermissionSchemeId [KEY]	String	False	PermissionSchemes.Id	=	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.