Allow particular group to delete records from specific table using acls

[Ankita3]

Hi,

We have this requirement of allowing particular group to have access to delete the records from one particular table.

Delete ACL should work but I am not able to figure out how. Can anyone help?

Regards,

Ankita

[amaradiswamy]

Hi Ankita,

Please create delete acl

tablename . none

advanced is true

script:

answer = gs.getUser.isMemberOf('groupnameor sys_id');

Thanks and regards

Swamy

[suri · Accepted solution]

Hi Ankitha,

To achieve this functionality you have to write an acl script on delete

Firstly you have to get Elevate roles.

Create   a ACL

Type: record

Operation : Delete

Name: table name

Advanced script:

if(gs.getUser().isMemberOf(group name)){

  answer=true;

}

  else

  {

  answer=false;

  }

    PS: Hit like, Helpful or Correct depending on the impact of the response                                                    

[Ankita3]

Hi,

Glad to tell you that it did work. It was first time I was working with delete operation acls.

Thanks to all

Regards.

[prithvirajchaud]

You can assign roles to groups and then define the acl for those specific roles