Permission Strings Matrix

Upload Wizard details (for fine-tuning access) Permission String Result
Query Wizard Upload Wizard Add Chg Del Ignore Pre-Inq Det line init Multi- thread
/ / / / / x x x ALLOW The user has full access to both the QueryWizard and the UploadWizard, but not to "Ignore Pre-inquire Status", "Detail Line Initialization" and "Multi-threading" features.
x x x x x x x x DENY The user does not have access to any Add-Ins functionality.
x / / / / / / / Dxxxxxxx The user does not have access to the Query Wizard, but has full access to the Upload Wizard.
/ x x x x x x x ADxxxxxx The user has access to full QueryWizard functionality, but is blocked from using any part of the UploadWizard.
/ / x x x x x x AADDDDDD The user has access to both the QueryWizard and the UploadWizard, but is blocked from adding, changing, and deleting records. (Therefore, the user can only use the Query Wizard).
/ / / x x / / / AAADDAAA The user can use the QueryWizard, and UploadWizard to add records only, and has special access to "Ignore Pre-inquire Status", "Detail Line Initialization" and "Multi-threading" features.
/ / x / x / / / AADADAAA The user can use the QueryWizard, and the UploadWizard to change records only, and has special access to "Ignore Pre-inquire Status", "Detail Line Initialization" and "Multi-threading" features.
/ / / / x / / / AAAADAAA The user can use the QueryWizard, and the UploadWizard to both add and change records but is blocked from deleting records, and has special access to "Ignore Pre-inquire Status", "Detail Line Initialization" and "Multi-threading" features.
/ / x x / / / / AADDAAAA The user can use the QueryWizard, and the UploadWizard to delete records only but is blocked from adding or changing any records, and has special access to "Ignore Pre-inquire Status", "Detail Line Initialization" and "Multi-threading" features.
/ / / x / / / / AAADAAAA The user can use the QueryWizard, and the UploadWizard to add and delete records but is blocked from changing any records, and has special access to "Ignore Pre-inquire Status", "Detail Line Initialization" and "Multi-threading" features.
/ / / / / / / / AAAAAAAA The user has access to all features.

Optional Permission Character for Protected Worksheets

You can add an optional character permission at the end of any of the above listed permission strings. This will determine whether the user is allowed to upload protected worksheets without being prompted with password input. This table shows the optional characters:

Table 1.
Optional Character New Permission String Description
A AAAAAAAAA, AADADAAA The user is able to upload a protected worksheet without being prompted for a password input.
D AAAAAAAAD, AADADAAD The user is prompted for a password input when uploading a protected worksheet.
Note: By default, this optional permission is assumed to be DENIED when not added to the current 8-character permission string format.