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...

[Siva Jyothi M]

@VSN,

Try checking if any other ACL's are contradicting this, check the other ACL's written on the program_user table.

[VSN]

@Siva Jyothi M their is 1 acl on the worknotes field, 

Read- worknotes- snc internal role.

but after de-activating that also user not able to see worknotes.

[Sandeep Rajput]

@VSN Please use the following steps to achieve the intended functionality.

1. I have a requirement to create a new user role,(ex: Program_user): - Add a new role in sys_user_role table

2.the user who is part of program_user role should be able to open and review the program table records:- Create a read ACL on program table. Select * in field dropdown. This will provide read access on all the fields of program table.

3. Make sure that either the write ACL for program table doesn't exist or if it exists it should not have program_user role listed in the roles list.

Hope this helps.

[VSN]

@Sandeep Rajput  I have create new ACL type as "read" and "*". but it not showing records.

[Sandeep Rajput]

@VSN Could you please post the screen shot of your read ACL.