ACL to access a table

[VSN]

1.I have a requirement to create a new user role,(ex: Program_user).

2.the user who is part of program_user  role should be able to open and review the program table records. 

3.And also program_user sould not be able to edit the fields on program table.

I have to achieve this functionality by using ACL only...

[Aman Kumar S]

You can just create a read ACL on the program table and keep requires role as program_user.

[Anil Lande]

Hi,

You can create a Role and Read ACL for Program table like below.

Just use your new role in the roles List instead of sn_ppm.read.

[VSN]

@Anil Lande  i have created Read acl , but still user not able to access.  

FYI:

[Siva Jyothi M]

Hi @VSN,

Create a new role(Program_user). You would need to create two ACL's here. one is read ACL and the other is write ACL. First create read ACL on the Prgram_table and provide the program_user in the roles of the ACL. And create one more ACL that is (Program_table) (*) and provide the role in the roles of the ACL. 

Mark this answer as correct and helpful if it solves your issue.

Regards,

Siva Jyothi.