write access on custom table

[Rajesh Sheela1]

I created one custom table with not extended from any table and this is under incident module. This table editable only by admin role. Rest roles will have read access to the data in the table published as module. Can anyone suggest me how to achieve this?

[Aman Kumar S]

Setup CRUD ACLS for the table, where you can have create write ACL as admin in Requires role.

If you want to it to be open for the roles, and have an ACL for read with snc_internal role.

[Basheer]

Hi @Rajesh Sheela1 

You need to create an write ACL on the custom table

Navigate to user menu

Elevate previlege

Navigate to ACL

Create ACL

Operation : record

type : write

table : custom.none

role : admin

Before this you need to provide read access for that as well create an read ACL

Operation : record

type : read

table : custom.none

role : no role needed

Let me know if you need more help

[manjusha bangal]

Hi Rajesh,

You have to create read and write acl for the new custom table.

In write acl specify admin roles in roles section so only admin users can edits records of the table.

Create another read acl,in the roles section add role which should have read access to the data.

Thanks,

Manjusha Bangale