ACL: How Do i restrict table columns to specific group?

wais · ‎01-20-2017

New to ACL. We would like to restrict few columns/fields in a table to allow write permission to only specific group, how do I do that?

Brian104 · ‎05-18-2022

First you want want to allow these group members access to write to the table with the following "write" ACL:

Operation: "write"

Name: "table.None"

Advanced script: user.isMemberOf('yourGroupName');

Second: Restrict all columns from that group by creating a ACL for accessing all columns to another role

Operation: "write"

Name: "table.*"

Role: "default table role"

Third: Grant "write" access to your specific column

Operation: "write"

Name: "table.yourColumn"

Advanced script: user.isMemberOf('yourGroupName');