UsersPermissions
Returns the full set of permission flags for a specific user, indicating which actions the user is authorized to perform within Pipedrive.
View-Specific Information
SELECT
The provider uses the Pipedrive API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the provider.
| Column | Supported Operators |
| UserId | = |
For example, the following query is processed server-side:
SELECT * FROM UsersPermissions WHERE UserId = 13822542
Columns
| Name | Type | References | Description |
| UserId | Integer | ID of the user. | |
| CanAddCustomFields | Boolean | Indicates whether the user is permitted to create new custom fields. | |
| CanBulkEditItems | Boolean | Indicates whether the user is permitted to edit multiple records simultaneously using bulk operations. | |
| CanChangeVisibilityOfItems | Boolean | Indicates whether the user is permitted to change the visibility settings of records. | |
| CanCreateOwnWorkflow | Boolean | Indicates whether the user is permitted to create personal automation workflows. | |
| CanModifyOwnerForDeals | Boolean | Indicates whether the user is permitted to reassign deal ownership to another user. | |
| CanDeleteDeals | Boolean | Indicates whether the user is permitted to delete deal records. | |
| CanConvertDealsToLeads | Boolean | Indicates whether the user is permitted to convert existing deals into leads. | |
| CanMergeDeals | Boolean | Indicates whether the user is permitted to merge two deal records into one. | |
| CanEditDealsClosedDate | Boolean | Indicates whether the user is permitted to modify the closed date of a deal. | |
| CanModifyOwnerForLeads | Boolean | Indicates whether the user is permitted to reassign lead ownership to another user. | |
| CanDeleteLeads | Boolean | Indicates whether the user is permitted to delete lead records. | |
| CanMergeLeads | Boolean | Indicates whether the user is permitted to merge two lead records into one. | |
| CanSeeDealsListSummary | Boolean | Indicates whether the user is permitted to view the summary totals row at the bottom of the deals list. | |
| CanAddDeals | Boolean | Indicates whether the user is permitted to create new deal records. | |
| CanEditOtherUsersDeals | Boolean | Indicates whether the user is permitted to edit deal records owned by other users. | |
| CanAddLeads | Boolean | Indicates whether the user is permitted to create new lead records. | |
| CanEditOtherUsersLeads | Boolean | Indicates whether the user is permitted to edit lead records owned by other users. | |
| CanEditCustomFields | Boolean | Indicates whether the user is permitted to modify existing custom field definitions. | |
| CanDeleteCustomFields | Boolean | Indicates whether the user is permitted to delete custom field definitions. | |
| CanUseImport | Boolean | Indicates whether the user is permitted to import data into Pipedrive. | |
| CanModifyLabels | Boolean | Indicates whether the user is permitted to create, edit, or delete record labels. | |
| CanExportDataFromLists | Boolean | Indicates whether the user is permitted to export data from list views. | |
| CanShareFilters | Boolean | Indicates whether the user is permitted to share saved filters with other users. | |
| CanEditSharedFilters | Boolean | Indicates whether the user is permitted to modify filters shared by other users. | |
| CanShareInsights | Boolean | Indicates whether the user is permitted to share Insights reports and dashboards with other users. | |
| CanUseEmailTracking | Boolean | Indicates whether the user is permitted to use email open and click tracking features. | |
| CanSeeOtherUsersStatistics | Boolean | Indicates whether the user is permitted to view performance statistics for other users. | |
| CanSeeCompanyWideStatistics | Boolean | Indicates whether the user is permitted to view aggregate statistics across the entire company. | |
| CanSeeOtherUsers | Boolean | Indicates whether the user is permitted to view the profiles and details of other users. | |
| CanFollowOtherUsers | Boolean | Indicates whether the user is permitted to follow other users to receive updates on their activity. | |
| CanSeeHiddenItemsNames | Boolean | Indicates whether the user is permitted to see the names of records that are otherwise hidden from them. | |
| CanModifyOwnerForActivities | Boolean | Indicates whether the user is permitted to reassign activity ownership to another user. | |
| CanDeleteActivities | Boolean | Indicates whether the user is permitted to delete activity records. | |
| CanModifyOwnerForPeople | Boolean | Indicates whether the user is permitted to reassign person record ownership to another user. | |
| CanDeletePeople | Boolean | Indicates whether the user is permitted to delete person records. | |
| CanMergePeople | Boolean | Indicates whether the user is permitted to merge two person records into one. | |
| CanModifyOwnerForOrganizations | Boolean | Indicates whether the user is permitted to reassign organization record ownership to another user. | |
| CanDeleteOrganizations | Boolean | Indicates whether the user is permitted to delete organization records. | |
| CanMergeOrganizations | Boolean | Indicates whether the user is permitted to merge two organization records into one. | |
| CanAddProducts | Boolean | Indicates whether the user is permitted to create new product records. | |
| CanEditOtherUsersProducts | Boolean | Indicates whether the user is permitted to edit product records owned by other users. | |
| CanModifyOwnerForProducts | Boolean | Indicates whether the user is permitted to reassign product record ownership to another user. | |
| CanDeleteProducts | Boolean | Indicates whether the user is permitted to delete product records. | |
| CanDeleteProductVariations | Boolean | Indicates whether the user is permitted to delete product variation records. | |
| CanUseApi | Boolean | Indicates whether the user is permitted to access the Pipedrive API. | |
| CanAddPeople | Boolean | Indicates whether the user is permitted to create new person records. | |
| CanEditOtherUsersPeople | Boolean | Indicates whether the user is permitted to edit person records owned by other users. | |
| CanAddOrganizations | Boolean | Indicates whether the user is permitted to create new organization records. | |
| CanEditOtherUsersOrganizations | Boolean | Indicates whether the user is permitted to edit organization records owned by other users. |