DB connector || Duplicate account being created for Inactive accounts

[arushi2403]

Hi,

We are integrating with an application using DB connector where we are facing the issue of new account creation even when an inactive account exists for the application.

We have a user which has an inactive application account.

We have application roles in the system and we assign that user with a role.

We observe that a new account request is created in Saviynt where as it should not have done anything on the inactive account. 

So now the user has 2 application accounts. and this will happen every time we add a role to a user which has an inactive application account

Any suggestions on why this is happening.

[Saathvik]

@arushi2403 : In AccountName rule did you configure Check Unique Account with Active, Inactive etc? If not can you configure this(select whatever statuses you want to validate for uniqueness) and see if you are still seeing the same issue.

[arushi2403]

The check Unique account is set to All. So essentially it should check for all accounts(active/inactive).

[Saathvik]

@arushi2403 : Instead of ALL can you select specific statuses and see

[rushikeshvartak]

Please add account exists json for DB connector

[arushi2403]

{
"AccountExistQry" :"SELECT * FROM dba_users DU where DU.USERNAME='${accountName}'"
}

[rushikeshvartak]

{"AccountExistQry" : ["SELECT * FROM DBA_USERS WHERE USERNAME= '${accountName}'"] }

What does logs show result of above it goes to create / update account json