Record Access working local, not while hosted

[Joost Miltenburg]

Hi All,

I added security to limit the DataAPI user from accessing certain records, with the limited option. I tested this while running these files on my HD no server. Worked like a charm. After moving the files to FMServer the DataAPI account can access all record in the table all of a sudden.

Any thoughts as to why this is happening?

Kind regards,

Joost

[bcooney]

What is the calc for rla? 

[Joost Miltenburg]

not(IsEmpty(Trim( ind_sent_to_website )))

For both the view and edit options.

Very basis, IMHO.

Edited November 4, 2019 by Joost Miltenburg
added comment

[Wim Decorte]

A couple of things to check:

- the calc context of the RLA calc

- in production does the Data API account have the correct priv set attached?

- check the data in "ind_sent_to_website"