Restricting data based on user role and division

[Community Alums]

I am new to development and am trying to figure the best approach to restrict data access on the goal table to users within their division. Any direction with this would be appreciated.

[jaheerhattiwale]

@Community Alums Create Read ACL on goal table and add the script to restrict.

[kingkong]

@Community Alums , If possible the best approach will be to create a group and users in the group depending on their division. Also don't forget to add the roles to the group that will provide the access, read, write privilege to all the members of the group.

as an alternate you can go for the ACL's.

[Community Alums]

I have groups created for the users. I was looking at using a before query business rule but running into issues getting it to work properly.