Evaluation of ACL while running the transform maps

[Abhijith322]

Hi ServiceNow enthusiasts,

Let me brief the scenario.

I have a staging table (x) and a transform map configured to insert data into the target table (y). The scheduled import has been set to run on behalf of a non-admin user having write roles in the table y. Along with that, there is a field-level read ACL set up on a particular field, and that particular field has been set as the coalesce field in the field mapping. Here comes the question: in the absence of the read privilege on the field, is there a chance of duplication of records in table y ?

[Vladimir6]

The best way to get right answers is to suggest a potnetially wrong one 🙂

It seems to  me, that the transfer from the Staging Table to the Targen Table happens with System rights. No ACLs are checked.

[jasonshone]

Hi Is this correct?  I am struggling to get an answer but i am led to believe field level ACLs will be evaluated before the record insert on Transform Map load