Click HERE to see how Saviynt Intelligence is transforming the industry. |
09/25/2024 05:13 AM
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!
09/25/2024 05:36 AM
{
"Role": [
"UPDATE tblabc SET ${entitlementValue} = 'false' WHERE loginid = '{accountName}'"
]
}
09/25/2024 05:43 AM
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 '='
09/25/2024 05:46 AM
Xyz is account name ?
09/25/2024 06:05 AM
Yes
09/25/2024 06:14 AM
{
"Role": [
"UPDATE tblabc SET ${entitlementValue} = 'false' WHERE loginid = {accountName}"
]
}