RolePermissions
Get the permissions associated with a role.
Table Specific Information
Select
The connector uses the Zoho Books API to process WHERE clause conditions built with the following columns and operators:
- RoleId supports the '=' comparison.
The rest of the filters are executed client-side in the connector.
For example:
SELECT * FROM RolePermissions WHERE RoleId = '1234';
Columns
| Name | Type | References | SupportedOperators | Description |
| RoleId [KEY] | String |
Roles.Id | Id of the role. | |
| Entity [KEY] | String | Entity. | ||
| RoleName | String | Name of the role. | ||
| DisplayName | String | Display name of the role. | ||
| Description | String | Description of the role. | ||
| Group | String | Group. | ||
| GroupFormatted | String | GroupFormatted. | ||
| EntityFormatted | String | EntityFormatted. | ||
| FullAccess | Boolean | FullAccess. | ||
| ApplySegment | Boolean | ApplySegment. | ||
| AssignOwner | Boolean | AssignOwner. | ||
| CanCreate | Boolean | CanCreate. | ||
| CanDelete | Boolean | CanCreate. | ||
| CanEdit | Boolean | CanEdit. | ||
| CanView | Boolean | CanView. | ||
| VendorBankAccount | Boolean | VendorBankAccount. | ||
| CanApprove | Boolean | CanApprove. | ||
| CanEditLockedRecords | Boolean | CanEditLockedRecords. | ||
| DontAllowExpenseTimesheet | Boolean | DontAllowExpenseTimesheet. | ||
| MorePermissions | String | MorePermissions. | ||
| DependentEntities | String | DependentEntities. | ||
| IsReportNewPermissionFlowEnabled | Boolean | IsReportNewPermissionFlowEnabled. | ||
| ReportPermissions | String | ReportPermissions. |