Returns the permission scheme currently assigned to each project.

View-Specific Information

SELECT

The connector uses the Jira API to process filters based on the ProjectId and ProjectKey columns. The connector processes all other filters client-side.

You must specify a ProjectId or ProjectKey to retrieve results. If neither is specified, the connector automatically queries the Projects table to retrieve the required identifiers. This may result in increased query times.

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

SELECT * FROM ProjectsPermissionScheme WHERE ProjectId = 10001;
SELECT * FROM ProjectsPermissionScheme WHERE ProjectKey = 'PROJ';

Columns

Name	Type	References	SupportedOperators	Platform	Description
ProjectId [KEY]	Integer		=		The unique numeric identifier of the project to which the permission scheme is assigned. Used to associate permissions with a specific Jira project.
ProjectKey	String		=		The project key is a short, unique identifier (such as 'PROJ') used to reference the project in URLs and issue keys.
Id [KEY]	String				The unique ID of the permission scheme that defines what users can see and do within the associated project.
Name	String				The display name of the permission scheme. This name is shown in the Jira UI and helps users and admins recognize the scheme.
Description	String				A brief explanation of the permission scheme's purpose or its specific configuration. This helps admins differentiate between similar schemes.