FeedPermissions
Retrieves the permissions for the specific feed.
Table Specific Information
Select
The driver uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:
- ProjectId supports the '=' operator.
- FeedId supports the '=' operator.
- ExcludeInheritedPermissions supports the '=' operator.
- IncludeIds supports the '=' operator.
NOTE: FeedId is required in order to query FeedPermissions.
For example:
SELECT * FROM FeedPermissions WHERE FeedId = 'e14f9853-4830-4f04-9561-c551254a32c9'
Columns
Name | Type | References | Description |
FeedId | String |
Feeds.Id | Id of the feed. |
ProjectId | String | Id of the project. | |
DisplayName | String | Display name for the identity. | |
IdentityDescriptorIdentifier | String | The unique identifier for this identity. | |
IdentityDescriptorType | String | Type of descriptor. | |
IdentityId | String | Id of the identity associated with this role. | |
IsInheritedRole | Boolean | Indicates whether the role is inherited. | |
Role | String | The role for this identity on a feed. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements, and offer a more granular control over the tuples that are returned from the data source. Unless otherwise specified, only the = operator is permitted when filtering on pseudocolumns.
Name | Type | Description | |
ExcludeInheritedPermissions | Boolean | True to only return explicitly set permissions on the feed. Default is false. | |
IncludeIds | Boolean | True to include user Ids in the response. Default is false. |