Does database connector supports locking/unlocking the account

[sk]

Team,

We want to implement unlock feature on the database accounts if account got locked because of failed attempts.

And we only want to this feature to be shown for admins not end users. So we thought of using unlock feature through Reset Account Password for others by enabling that feature only on Admin Sav Role.

But wanted to understand if the connector supports it or not. Looking at documentation looks like it is not: https://docs.saviyntcloud.com/bundle/Database-v23x/page/Content/Database-Integration-Overview-v2022....

Just want to confirm the same. If it supports can you please provide the instructions on how it can be achieved?

[sk]

Team any responses on this?

[mbinsale]

This is supported for Lock / Unlock capability using the DB Connector. This is mentioned in the documentation link that you referred.

In the DB Connector, you can use the ENABLEACCOUNTJSON to achieve this. The relevant query depends on the DB Type. An example is already available in the connection template.

[sk]

Sorry I couldn't find the section you referring where it says we can use DISABLEACCOUNTJSON /ENABLEACCOUNTJSON to achieve lock/unlock scenario.

So basically if I understand your statement correctly, We need to map account status with lock state? meaning if account is locked we mark it as disabled otherwise Active? 

[mbinsale]

Attaching the screenshot from the documentation.

And yes, the answer to your 2nd question. When the account is locked in the target, in Saviynt we mark the status as disabled and use the enableaccountjson to make the account active.

Hope this helps