delete security systems

[tatsuro_nomura]

I tried to delete a security system,  but cannot delete with the message below.

"This Security System has been used in other modules (for eg: request, attestation etc) of this application. To retain the audit data and maintain data integrity, this security system cannot be deleted."

I checked related objects, and the status are below. But I cannot delete the security system yet.

• Connection is deleted
• Endpoint is inactive
• Job with the system is nothing
• pending task with the system is nothing

Anyone know what should I check except for above?

Thanks.

[sudeshjaiswal · Accepted solution]

Hello @tatsuro_nomura,

You won't be able to delete the security system from UI, you can only disable the endpoints from UI.
For Disable the Security System, you need to use the Custom Query to disable the security System using the below query,

UPDATE securitysystems
SET    status = 0
WHERE  systemname = 'abc'
       AND status = 1
LIMIT 1; 

Thanks,

For Ref:- https://forums.saviynt.com/t5/identity-governance/best-practice-documentation-for-application-retire... 

[dgandhi]

We cannot delete the Security System, please disable it using below query:

[rushikeshvartak · Accepted solution]

Disable using query. Disable option not available on UI.

update securitysystems set status=0 where systemname='abc' and status=1 limit 1;

[tatsuro_nomura]

Hi all,

Thanks for userful replies.
Please let me know the things blow additionally.

• Am I correct to run custom queries on a job with Job_type = "Excute Extension Queries（**DEPRECATED**) (CUSTOM QUERY JOB)"?
• Which document is query defined?

Thanks,

[dgandhi · Accepted solution]

1. Yes thats correct.

2. The query wont be given in the documentation but the schema details are present in below mentioned document.

https://docs.saviyntcloud.com/bundle/SSM-DB-Schema-Reference-v55x/page/Content/Identity-Repository-S...