How to delete a user via SQL statement if access is denied via AWI
Release : 12.X
Component :
--show objects owned by old user:
select eh_ah_idnr, eh_name, eh_client from eh where eh_usr_idnr in (select oh_idnr from oh where oh_otype='USER' and oh_name = '[deleted user/department]' and oh_client = [client number])
--update objects in activities being run by old user to new user
update eh set eh_usr_idnr = (select oh_idnr from oh where oh_otype='USER' and oh_name = '[admin user/department]' and oh_client = [client number]) where eh_usr_idnr in (select oh_idnr from oh where oh_otype='USER' and oh_name = '[deleted user/department]' and oh_client = [client number])