read acl on specific field

[sunilsargam]

I need to create an ACL on core_comapny table but only NAME and CITY field shds be visible visible to the user. How can we achieve this with snc_internal role?

I do not have any read acl on snc_internal role for core_company table.

Thank you

Sunil.

[Ankur Bawiskar]

@sunilsargam 

what's your exact business requirement for this?

you will have to have field level READ ACL on other fields to block if user doesn't have snc_internal role

OR

you can use onLoad client script to hide those fields on form but those will be seen from list

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[sunilsargam]

i want to show only this 2 fields information to user when they open the table, no other field shd be visible. 

[Ankur Bawiskar]

@sunilsargam 

then create field level READ ACL on all fields of that table excluding Name and CITY and add admin in roles section

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[sunilsargam]

1. Table.None ACL with snc_internal role

2. Table.Field ACL with snc_internal role

3. Table.* ACL with snc_internal role

im not sure how to stop user from viewing all data except fields? the table.none will give access to all of the data right?