ODBC Driver for Azure DevOps

Build 22.0.8479


Retrieves the permissions for the specific feed.

Table Specific Information


The 本製品 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.
The rest of the filter is executed client-side in the 本製品.

NOTE: FeedId is required in order to query FeedPermissions.

For example:

    SELECT * FROM FeedPermissions WHERE FeedId = 'e14f9853-4830-4f04-9561-c551254a32c9'


Name Type References Description
FeedId String


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.


SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479