3 --delete all instances from permission.grp_perm_map first
4 DELETE FROM permission.grp_perm_map where perm in
5 (select id from permission.perm_list where code='SET_CIRC_MISSING');
7 --delete all instances from permission.usr_perm_map too
8 DELETE FROM permission.usr_perm_map where perm in
9 (select id from permission.perm_list where code='SET_CIRC_MISSING');
11 --delete from permission.perm_list
12 DELETE FROM permission.perm_list where code='SET_CIRC_MISSING';