We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

DB connector || Duplicate account being created for Inactive accounts

arushi2403
New Contributor
New Contributor

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.
6 REPLIES 6

sk
All-Star
All-Star

@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.


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

arushi2403
New Contributor
New Contributor

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

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


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

rushikeshvartak
All-Star
All-Star

Please add account exists json for DB connector


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

arushi2403
New Contributor
New Contributor

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

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

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


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.