Setting up Create, Read, Write and Delete ACL's
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-10-2022 05:29 PM
I've created a table called "Dream" I created a user role called Dream user to with the following ACL's: Create, Read, Write and Delete. I need the user to be able to create, delete and edit their own record but be able to read others. I created the following acl's but they don't work. Any assistance would be great.
Write ACL:
Create ACL:
Delete ACL:
Read ACL: has no script
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-11-2022 07:10 AM
Change the script to
answer = false;
if (current.sys_created_by.equals(gs.getUserName()))
answer = true;
use this script as is.
in the role section of ACL use both the roles
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-11-2022 07:19 AM
It still does not allow me to create a new record. When click new the whole page is looks like a read only page. Ex.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-11-2022 07:45 AM
You need to add create ACL for * like you did for none. It would solve this problem.
Also please make sure to add * ACL for others as needed as well, which could solve other problems you will see on read and write as well
Make sure there are no other ACL than the once that you are creating, while creating the table it would create some ACL as well.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-11-2022 06:30 AM