Access denied deleting a User via AWI

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

How to delete a user via SQL statement if access is denied via AWI

Environment

Release : 12.X

Component :

Resolution

--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])