8 Post-Installation Scripts to Remove TF Application Groups

This section provides the Scripts to Remove TF Application Groups after the installation of the sanctions application.

Execute the below script to remove the TF application group:

delete from CSSMS_USR_GROUP_DSN_MAP_UNAUTH where v_group_code in (select v_group_code from CSSMS_USRGRP_DSN_UNAUTH_PACK where v_app_id = 'OFS_TFLT' and v_group_code like 'TF%');
delete from CSSMS_USRGRP_DSN_UNAUTH_PACK where v_app_id = 'OFS_TFLT' and v_group_code like 'TF%';
delete from CSSMS_USR_GROUP_DSN_SEG_MAP where v_group_code in (select v_group_code from CSSMS_USR_GROUP_DSN_MAP_PACK where v_app_id = 'OFS_TFLT' and v_group_code like 'TF%');
delete from CSSMS_USR_GROUP_DSN_MAP_PACK where v_app_id = 'OFS_TFLT' and v_group_code like 'TF%';
delete from CSSMS_GROUP_ROLE_MAP_UNAUTH where v_group_code in (select v_group_code from CSSMS_GRP_ROLE_MAP_UNAUTH_PACK where v_app_id = 'OFS_TFLT' and v_group_code like 'TF%');
delete from CSSMS_GRP_ROLE_MAP_UNAUTH_PACK where v_app_id = 'OFS_TFLT' and v_group_code like 'TF%';
delete from cssms_group_role_map where V_GROUP_CODE in (select V_GROUP_CODE from cssms_group_role_map_pack where v_app_id = 'OFS_TFLT');
delete from cssms_group_role_map_pack where v_app_id = 'OFS_TFLT';
delete from DOCUMENT_USER_GROUP_MAP where v_usergroup_id in (select v_group_code from CSSMS_GROUP_MAST_PACK where v_app_id = 'OFS_TFLT' and v_group_code like 'TF%');
delete from CSSMS_GROUP_MAST where v_group_code in (select v_group_code from CSSMS_GROUP_MAST_PACK where v_app_id = 'OFS_TFLT' and v_group_code like 'TF%');
delete from CSSMS_GROUP_MAST_PACK where v_app_id = 'OFS_TFLT' and v_group_code like 'TF%';
delete from cssms_role_function_map where exists (select 1 from cssms_role_function_map_pack where cssms_role_function_map.v_function_code = cssms_role_function_map_pack.v_function_code
and cssms_role_function_map.V_ROLE_CODE = cssms_role_function_map_pack.V_ROLE_CODE and v_app_id = 'OFS_TFLT');
delete from cssms_role_function_map_pack where v_app_id = 'OFS_TFLT';
delete from CSSMS_ROLE_MAST_PACK where v_app_id = 'OFS_TFLT';
delete from CSSMS_FUNCTION_MAST_PACK where v_app_id = 'OFS_TFLT';