Cannot delete unused logins in Continuous Delivery Automation

book

Article ID: 109844

calendar_today

Updated On:

Products

CA Continuous Delivery Automation - Automation Engine

Issue/Introduction

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

<Please see attached file for image>

User-added image

 

Cause

The logins are currently referenced in existing deployment profiles. 

Environment

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

Resolution

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.

Attachments

1558697897957000109844_sktwi1f5rjvs16j4f.png get_app