-- This will remove the contact and SedonaWeb user created during the user creation process. This will allow them to recreate the user in order to test the email server setup in their SedonaWeb.
-- First find his Customer Contact ID
-- Replace CUSTOMER EMAIL ADDRESS with email of user
--This will display the Customer_Contact_ID
Select * from ws_account where account_name = ‘CUSTOMER EMAIL ADDRESS’
Select * from Ar_customer_contact where Customer_Contact_Id = 'CUSTOMER CONTACT ID'
--This delete the SedonaWeb user created.
Delete ws_account where account_name = ‘CUSTOMER EMAIL ADDRESS’
-- This deletes the customer contact created by SedonaWeb.
-- Replace CONTACT ID with value returned from CUSTOMER CONTACT ID
Delete ar_customer_contact where customer_contact_id = ‘CONTACT ID’
