Overview
Data flow destination, establishing user access permissions to entities.
Setup
The script has the following parameters:
- CrmConnection - selects COZYROC Dynamics CRM connection.
- TargetEntity (Mappings) - map input column containing target entity.
- TargetId (Mappings) - map input column containing target entity record identifier.
- PrincipalEntity (Mappings) - map input column containing principal entity.
- PrincipalId (Mappings) - map input column containing principal entity record identifier.
- AccessRights (Mappings) - map input column containing access rights. The input should contain integer value with combination of one or more of the following values:
Permission | CRM 2011 | CRM 4, CRM 3 |
None |
0 |
N/A |
ReadAccess |
1 |
1 |
WriteAccess |
2 |
2 |
AppendAccess |
4 |
4 |
AppendToAccess |
16 |
8 |
CreateAccess |
32 |
16 |
DeleteAccess |
65536 |
32 |
ShareAccess |
262144 |
64 |
AssignAccess |
524288 |
128 |
Configuration
To use this script, you would need to load it in COZYROC JavaScript Component. If you are using COZYROC SSIS+ 2.0 or later, after selecting the corresponding script type and opening the component editor, you can select the script from a dropdown list with the pre-built scripts. For COZYROC SSIS+ 1.9, you can download the JavaScript file and browse to it via the "Import JavaScript code" button.
Dynamics_CRM_User_Access_Destination.jsKnowledge Base
Related documentation
COZYROC SSIS+ Components Suite is free for testing in your development environment.
A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud.