Skip to content

How to: solve “Secure query included inaccessible field” within AddressTools

AddressTools’ triggers handle the standardization, validation, and some elements of verification in a Salesforce organization where the solution is configured.

However, in later versions of the package, changes in how permissions are checked may result in them throwing the following error message:

pw_ccpro.ValidateAccountBeforeSave: execution of BeforeUpdate caused by: System.QueryException: Insufficient permissions: secure query included inaccessible field (pw_ccpro)

To resolve this issue, ensure that users have the appropriate object and field permissions assigned. The required permissions are detailed in the table below and are also included in the packaged “AddressTools Premium Standard User” permission set.

ObjectObject PermissionField NameField Permission
UsersN/A

QuickComplete Country

Exempt Validation Errors

Read
CountriesView AllAll fieldsRead
StatesView AllAll fieldsRead
ZIP CodesView AllAll fieldsRead
Time ZonesView AllAll fieldsRead
Alternate Country NamesView AllAll fieldsRead
Alternate State NamesView AllAll fieldsRead
ZIP Code CountiesView AllAll FieldsRead

The user/profile will need access to the following Custom Setting Definitions:

  • CountryComplete Settings
  • AddressTools Fields to Validate
,

Discover more from ProvenWorks

Subscribe now to keep reading and get access to the full archive.

Continue reading