ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Cannot delete unused logins in Continuous Delivery Automation


Article ID: 109844


Updated On:


CA Automic Workload Automation - Automation Engine


When attempting to remove unused logins from CDA, the delete button cannot be selected:

<Please see attached file for image>

User-added image



The logins are currently referenced in existing deployment profiles. 


Release: AUTRLB99000-12.0-Continuous Delivery Automation-Base Edition


Find and remove the login references from the existing deployment packages.These can be found through the following steps:

1) Run the following query against the CDA database (where 'loginObjectName' is the name of the login to be deleted):

select LoginId from LoginObject where Name = 'loginObjectName'

This should return a numerical value, for example 123. 

2) Run the following query against the CDA database using the value generated from the above query:

select * from DeplProfile where LoginId = 123

3) The values under the 'Name' column indicate the Deployment Profiles where the login is still used. 

4) Remove the login from the Deployment Profiles. The delete button will now be available for the login.


1558697897957000109844_sktwi1f5rjvs16j4f.png get_app