Restrict access to table based on group
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-26-2023 11:31 PM
Hi Team,
I want to restrict the user with in the "manager group" which contains the roles "sn_wsd_manger" and "sn_wsd_rsv_case_reader" to create the new "workplace service" but they can should able to create the new "workplace service item" which is available in related list.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-26-2023 11:40 PM
You would need to edit the existing create ACL on this table and add the below line in advanced script of ACL
Harish

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-26-2023 11:53 PM
@Akshaya14 You need two Create ACL.
1. Create ACL on Workplace Service Table, this will be a scripted ACL where you can check
if(!gs.getUser().isMemberOf('manager group')){
answer = true;
}
else{
answer=false;
}
2. Second Create ACL should be defined on Workplace Service Items table as follows.
if(gs.getUser().isMemberOf('manager group')){
answer = true;
}
else{
answer=false;
}
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-27-2023 12:11 AM - edited 09-27-2023 12:15 AM
Hi @Akshaya14 ,
Create acl on workplace servicetable with below script.
if (!gs.hasRole('sn_wsd_manager') && !gs.hasRole('sn_wsd_rsv_case_reader') && gs.getUser().isMemberOf('manager_group')) {
answer = true;
} else {
answer = false;
}
Create acl on workplace service item table with below script.
if(gs.getUser().isMemberOf('manager group')){
answer = true;
}
else{
answer=false;
}
If it works, please mark it as helpful.
Thanks,
Anand