Why I'm not able to delete sys_user_grmember (global) records from custom app?

[Ankita Kolhe]

Hi Community,

As sys_user_grmember  table (which is in global scope) has can delete field unchecked. I created application cross scoped privilege record but still not able to delete record from custom app.

Background script:-

var grMember = new GlideRecord('sys_user_grmember');  

 grMember.addQuery('group', '574a576247f7ed100687650f436d4346');  

  grMember.addQuery('user', 'IN' , '811460fb97466910a7157be71153af25');  

 grMember.query();  

 grMember.deleteMultiple();

Also, I checked 'Can Delete' field in group member table still it's not working:-

Could anyone please help me on this?

Thanks

[Aman Kumar S]

Hi @Ankita Kolhe 

deleteMultiple() is not supported in scoped application, better use a while loop and delete record individually

var grMember = new GlideRecord('sys_user_grmember');  

 grMember.addQuery('group', '574a576247f7ed100687650f436d4346');  

  grMember.addQuery('user', 'IN' , '811460fb97466910a7157be71153af25');  

 grMember.query();  

while(grMember.next()){

 grMember.deleteRecord();

}

[Ankita Kolhe]

Hi @Aman Kumar S ,

Thanks much for your response.

I changed the code. But still getting below error:-

[Aman Kumar S]

 @Ankita Kolhe 

Try using the script in a scheduled job or fix script

[Prince Arora]

@Ankita Kolhe 

I believe the checkbox will resolve your query

Configure the table and make the "can delete" checkbox active true in the Application access

If my answer solved your issue, please mark my answer as ✅ Correct & 👍Helpful based on the Impact.