DB connector Revoke access

[AtrayeeDutta]

Hi Team,

We have an usecase where we need to update an Entitlement attribute value to "0" in DBon revoke access for a Database connector.

Can we do that? can we do that?while running the retry job, its saying error in executing query.

Any information on this will be helpful

Regards,

Atrayee

[RakeshMG]

Could you please share the error you are getting

[AtrayeeDutta]

Hi Rakesh,

2023-05-25T17:33:12+05:30-ecm-worker-2023-05-25T12:03:11.92821013Z stdout F 2023-05-25 12:03:11,928 [quartzScheduler_Worker-1] ERROR provisoning.DBProvisioningService - Error occured in Excecuting Query

2023-05-25T17:33:12+05:30-ecm-worker-2023-05-25T12:03:11.938179588Z stdout F 2023-05-25 12:03:11,938 [quartzScheduler_Worker-1] ERROR provisoning.DBProvisioningService - Error occured while revoking access -1 Exception occured while Excecuting Query

This is the JSON

{

"ADMIN_KBN" : [
"UPDATE *****Tablename* set ADMIN_KBN='0' where MAIL_ADRESS='oscar*******"
]
}

We need to use an update query but not a delete query. is update query allowed in revoke json?

[rushikeshvartak]

Does same query works in application ?

ADMIN_KBN is Entitlement Type Name/ Display Name

[AtrayeeDutta]

Hi @rushikeshvartak 

ADMIN_KBN is the Entitlement Type Name.

Regards

Atrayee

[AtrayeeDutta · Accepted solution]

This issue is resolved, there was some permission issue.

Regards,

Atrayee