Scoped app sys fields, how to make read only?

[JusCuz]

I'm working on a new scoped app, I would like to make sys_created_on and sys_created_by read only on a new table. I cannot see a way to do this, the read only checkbox is greyed out, I cannot create a field level ACL, it's not a selectable option for a UI Policy or Data Policy. How do you set these fields read only? (ok, the real answer that's always in my mind is why are they not read only by default but that's another story)

[Srinivas Balusu]

Hai Jason,

After checking all the possibilities (which I am familiar of) including what you mentioned above (like UI Policies etc...) I failed in making them readonly.

But I am able to find a workaround for you which couldn't be a great idea. But you can give a try if the number of columns are less in number and this requirement is so critical.

1. Set your write ACL , tableName.* set to always false;

2. Set the write ACL'son all other fields to true and other required scenarios.

This worked for me.

[JusCuz]

Hmmm....yea that solution did cross my mind, guess I should have tried it. What a pain. Thank you.

[paige6]

I was able to change the sys_* fields of my custom app form to read only in the Form Designer.

[Jonatan Horvath]

I tried this and it did not work for me. Did you make the adjustment on a table that's been extended?

Changes made in the DEV-instance is applied accordingly but the update for the sys_* columns are not published with the other updates.