Delete unused roles

Description

Delete the unused roles "FA User" and "Packaging User"

Environment

None

Activity

Show:
Hiep Lq
October 2, 2013, 3:07 AM

when run this script i encounter below error message

"psql:./i1.0z/postgresql/201309302132_IDEMPIERE-1411.sql:4: ERROR: update or delete on table "ad_role" violates foreign key constraint "adrole_addocumentactionaccess" on table "ad_document_action_access"
DETAIL: Key (ad_role_id)=(50002) is still referenced from table "ad_document_action_access"."

maybe script update to

DELETE FROM ad_document_action_access WHERE AD_Role_ID=50002

DELETE FROM ad_infowindow_access WHERE AD_Role_ID=50002

DELETE FROM AD_Role WHERE AD_Role_ID=50002

DELETE FROM ad_document_action_access WHERE AD_Role_ID=50001

DELETE FROM ad_infowindow_access WHERE AD_Role_ID=50001

DELETE FROM AD_Role WHERE AD_Role_ID=50001

Assignee

Carlos Ruiz

Reporter

Carlos Ruiz

Labels

None

Tested By

None

Fix versions

Priority

Major
Configure