MyPermissions
Returns the permissions granted to the current user based on their roles and group memberships.
テーブル固有の情報
Select
connector は、このテーブルで指定されたすべてのフィルタをクライアント側でconnector 内で処理します。
SELECT * FROM MyPermissions
Columns
| Name | Type | References | SupportedOperators | Platform | Description |
| Id [KEY] | Integer | Common | A unique numeric identifier representing a specific permission available to users in Jira. | ||
| Key [KEY] | String | Common | The internal string identifier for the permission, used when managing or referencing permissions through the Application Programming Interface (API) or configuration files. | ||
| Name | String | Common | The human-readable name of the permission, indicating the action the permission allows (such as 'Browse Projects' or 'Edit Issues'). | ||
| Type | String | Common | Specifies the scope or context of the permission, such as 'project', 'issue', or 'global', determining where the permission applies. | ||
| Description | String | Common | A detailed explanation of what the permission allows the user to do within the specified scope, providing context for its use. | ||
| HavePermission | Boolean | Common | If the value is 'true', the current user has this permission in the given context (project, issue, etc.); if 'false', the user does not. | ||
| DeprecatedKey | Boolean | Common | If the value is 'true', the permission key is considered outdated and should not be used in new configurations; if 'false', it is still valid. | ||
| Permissions | String | = | Common | A comma-separated list of related or grouped permissions relevant to the current context, such as 'BROWSE_PROJECTS, EDIT_ISSUES'. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| ProjectKey | String | Filters the permission check to a specific project by its key (for example, 'DEV'), which helps evaluate permissions within that project only. | |
| ProjectId | String | Filters the permission check to a specific project by its ID. Used to assess if the user has the permission in that project. | |
| IssueKey | String | Filters the permission check to a specific issue by its key (for example, 'DEV-101'), allowing permission evaluation in the context of that issue. | |
| IssueId | String | Filters the permission check to a specific issue by its internal numeric ID, used for querying permissions at the issue level. |