Need help with Update Statement for RevokeAccessJSON

[LoneWolf2020]

Hello,

I am trying to update the DB table of one of the applications via Revoke Access JSON (Access Removal scenario - User Access Review)

In this scenario, entitlement value is one of the columns in the DB. For example:

A, B & C are 3 entitlements and it holds true/false values in the DB table

If the reviewer decides to retain access A and revokes B & C for a particular user, then revokeaccessjson should update false for access B & C and ignore Access A.

I have configured the following update query. But it is ending up in error:

{
    "Role": [
        "UPDATE tblabc set '${entitlementValue}'='false' where loginid = '{accountName}'"
    ]
}

I am getting the following error:

Error while revoking access - B to account - xyz -Incorrect syntax near ''.

Can you please help here?

Thanks!

[rushikeshvartak]

{
    "Role": [
        "UPDATE tblabc SET ${entitlementValue} = 'false' WHERE loginid = '{accountName}'"
    ]
}

[LoneWolf2020]

Hi @rushikeshvartak ,

Yes. I tried this statement as well. For this, I am getting the following error:
Error while revoking access - A to account - xyz -Incorrect syntax near '='

[rushikeshvartak]

Xyz is account name ?

[LoneWolf2020]

Yes

[rushikeshvartak]

{
    "Role": [
        "UPDATE tblabc SET ${entitlementValue} = 'false' WHERE loginid = {accountName}"
    ]
}