Below is an example string that shows the formatting for the permissions cell per user.
[BG]CUDV-[BD]CUDV-[BS]CUDV-[BU]CUDV-[CC]CUDV-[DS]CUDV-[IN]CUDV-[NC]CUDV-[PR]CUDV-[P]CUDV-[PJ]CUDV-[PO]CUDV-[R]CUDV-[S]CUDV-[TC]CUDV-[U]CUDV
This might seem complicated, but do not worry! It directly refers to this permissions panel for each user:
The above example essentially grants the user every permission. The two letters within the square brackets are the ‘row’ of this table:
Business Budget ([BG]), Business Division ([BD]), Business Settings ([BS]), Business Unit ([BU]) and so on.
The four letters immediately after the code are the vertical columns. The C refers to the Create permission, the U refers to the Update permission, and D and V refer to Delete and View respectively.Â
For each user, you will need to adjust this format to represent the permissions needed for each user. For example, if I wanted a user to be able to Create, Update, and View, but not Delete, for a row, you would include only the two letter code, followed by ‘CUV’ (e.g [IN]CUV). Each section must be separated by a hyphen.
Below is an example import string for a user with a more complex permission requirement in their business:
[BG]-[BD]V-[BS]-[BU]V-[CC]CUDV-[DS]V-[IN]CUDV-[NC]CUDV-[PR]CUDV-[P]CV-[PJ]V-[PO]CUV-[R]CUDV-[S]V-[TC]V-[U]
When imported, the user permissions will look like this: