ACL Issue on reference field

[bscherer]

I am having an odd issue with a reference field and acls on the destination table.

Table B references two fields on Table A.  These fields are not visible from Table B form, but work fine when hitting Table B directly.

Debugging Security,  I see a True check for base table access, True for access to both fields and a failure check for Base Table/.* fields.

I feel like i'm missing something obvious here.

Thanks

[Daniel O_Connor]

Do you have a tablea.<none> and tablea.* read ACL for the custom role? 

• TableA.<none>(as in no fields selected) provides the role access to the table
• TableA.* provides access to the fields in the table
• TableA.<field> provides access to the specific field

I'd a similar problem to yourself and someone explained the above to me. This three level of ACL seems to work for whatever I need in terms of providing field access on custom roles or custom tables.

[bscherer]

Thanks for the reply Daniel.

When i add TableA.*, in addition to the specific fields, all fields on the table are accessible. 

[bscherer · Accepted solution]

Looked at it again this morning and have it working now.

TableA/Read - Role

TableA.*/Read - Script: answer=false; - Role

tableA.Field1/Read - Role

TableA.Field2/Read - Role

[Daniel O_Connor]

Glad to hear.

I've got my head around ACL's in the last while but used to be probably the most frustrating part of custom apps I'd do