Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

DB connector Revoke access

AtrayeeDutta
Regular Contributor
Regular Contributor

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

5 REPLIES 5

RakeshMG
Saviynt Employee
Saviynt Employee

Could you please share the error you are getting

 


​Regards

Rakesh M Goudar

AtrayeeDutta
Regular Contributor
Regular Contributor

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?

Does same query works in application ?

ADMIN_KBN is Entitlement Type Name/ Display Name

 


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

Hi @rushikeshvartak 

ADMIN_KBN is the Entitlement Type Name.

Regards

Atrayee

AtrayeeDutta
Regular Contributor
Regular Contributor

This issue is resolved, there was some permission issue.

Regards,

Atrayee