Click HERE to see how Saviynt Intelligence is transforming the industry. |
05/31/2024 01:55 AM
What is the difference between Custom query to enhanced query.
why these custom queries needs to be converted to enhanced queries.
Any details articles from Saviynt please share.
05/31/2024 02:52 AM
Hi @Saviyntreh ,
Post 23.7 Saviynt introduced a new Enhanced Query Execution job to address potential security issues and improve the overall stability of the system in the Saviynt environment.
Discontinued the Execute Extension Queries (CUSTOMQUERYJOB): The existing job instances of Execute Extension Queries (CUSTOMQUERYJOB) continue to run. However, no new instances of this job can be created, and any attempt to modify the existing instances of the job are prevented by the system.
Refer below document:
05/31/2024 08:27 AM
Custom Query like it is normal script to execution SQL and it will support till 23.7v , and some of reason performance issue it got deprecated , newly relased Enhanced query bulid version,
new version Enhaced query some restiction provided to update and insert statments also majorly , if more info please check below docment:
05/31/2024 09:38 AM
Refer https://forums.saviynt.com/t5/identity-governance/enhanced-query-saviynt-upgrade-to-v23-11/m-p/64669
custom query was allowing all database table to update which was causing database deadlock
enhanced query allow selected columns and tables to update with roll back option in case of failure