Permissions
Details sharing and access permissions for files and folders within a OneDrive drive, identifying owners and collaborators.
Table Specific Information
UserId and GroupId connection properties can also be used to filter records. If both are included in the connection string, UserId will take precedence over GroupId.
Due to API limitations, all operators on this view are executed client-side.
Columns
| Name | Type | References | Description |
| id [KEY] | String | Unique identifier for the permission record. | |
| Etag | String | Entity tag used for concurrency control to track updates to the permission. | |
| ResourceId [KEY] | String | Identifier of the resource (file or folder) the permission applies to. | |
| grantedTo_user_displayName | String | Display name of the user who has been granted access to the resource. | |
| grantedTo_user_email | String | Email address of the user who has been granted access. | |
| grantedTo_user_id | String | Unique identifier of the user granted access. | |
| expirationDateTime | Datetime | Timestamp indicating when the permission will expire, if set. | |
| grantedTo_application_displayName | String | Name of the application granted access to the resource. | |
| grantedTo_application_id | String | Unique identifier of the application granted access. | |
| grantedToIdentities | String | List of user or group identities that the permission has been granted to, separated by commas. | |
| hasPassword | Bool | Indicates whether the shared link is protected by a password. | |
| inheritedFrom_driveId | String | ID of the drive where the original permission was inherited from. | |
| inheritedFrom_driveType | String | Type of the originating drive, such as personal or business. | |
| inheritedFrom_id | String | ID of the resource from which the permission is inherited. | |
| inheritedFrom_name | String | Name of the resource from which the permission is inherited. | |
| inheritedFrom_path | String | Path to the source resource from which the permission is inherited. | |
| inheritedFrom_shareId | String | ID of the sharing link associated with the inherited permission. | |
| inheritedFrom_sharepointIds_listId | String | SharePoint list ID from which the permission is inherited. | |
| inheritedFrom_sharepointIds_listItemId | String | ID of the SharePoint list item the permission is derived from. | |
| inheritedFrom_sharepointIds_listItemUniqueId | String | Globally unique identifier (GUID) of the SharePoint list item. | |
| inheritedFrom_sharepointIds_siteId | String | SharePoint site ID from which the permission originates. | |
| inheritedFrom_sharepointIds_siteUrl | String | URL of the SharePoint site associated with the inherited permission. | |
| inheritedFrom_sharepointIds_tenantId | String | Tenant ID associated with the originating SharePoint environment. | |
| inheritedFrom_sharepointIds_webId | String | Web ID for the SharePoint subsite containing the original resource. | |
| inheritedFrom_siteId | String | Site ID of the location from which the permission is inherited. | |
| invitation_email | String | Email address of the person invited to access the resource. | |
| invitation_invitedBy_application_displayName | String | Display name of the application that sent the sharing invitation. | |
| invitation_invitedBy_application_id | String | ID of the application that issued the sharing invitation. | |
| invitation_redeemedBy | String | Email or identifier of the person who accepted and redeemed the sharing invitation. | |
| invitation_signInRequired | Bool | Indicates whether the recipient must sign in to access the resource. | |
| link_application_displayName | String | Display name of the application that created the sharing link. | |
| link_application_id | String | Unique identifier of the application that created the sharing link. | |
| link_preventsDownload | Bool | Indicates whether downloading the shared content is restricted for viewers. | |
| link_scope | String | Defines the access scope of the sharing link, such as anonymous, organization, or specific people. | |
| link_type | String | Type of sharing link created (for example, view, edit, embed). | |
| link_webHtml | String | HTML-formatted snippet that renders the sharing link for embedding in web pages. | |
| link_webUrl | String | Direct web URL to access the shared item. | |
| roles | String | Comma-separated list of roles granted by the permission, such as read, write, owner. | |
| shareId | String | Unique identifier for the sharing instance, used to reference and manage shared access. |