CC 5.2_09 Rule Architect Tab -> Risks -> Delete .... Mass Delete Option?

[Former Member]

I have an opportunity where I'd like to mass delete my risks and rules and reload them. During an SP update, our Basis team appended to our rules with the SAP "out-of-the-box" rules. I'd like to get to the point of deleting everything (rules and risks) and start over. Does anyone have an option available to do this so that I can reload everything from scratch? We only have CC/RAR and FF/SPM in use right now, so no other module will be affected.

Thanks,

Greg

[Former Member · Accepted solution]

Greg,

There is no direct way to do that. SAP also does not have any direct way other than deleting the rules from Database. Open a message with SAP and ask them to provide you with rule deletion script. Using this script, you can delete only rules from your CC/RAR.

Regards,

Alpesh

[Former Member]

Greg,

Do not use any other delete script other than the one provided by SAP. Ifn case of an issue, SAP should be able support it if you have used the script provided by SAP.

Regards,

Alpesh

[former_member366047]

Greg-

Just to be clear, please open a CSS message to request the delete script from SAP. Do not use any delete statements posted on this forum.

Ankur

SAP GRC RIG

[Former Member]

If you want to remove ALL CC data, you'll have to remove all data from all CC tables in SQL. If you only want to remove select amounts of data, you might want to open an SAP ticket to get the most updated script for your release and flavor of SQL, but here's a sample script:

DELETE FROM SAPSECDB.VIRSA_CC_ACTRULE

DELETE FROM SAPSECDB.VIRSA_CC_ALLASTRUN

DELETE FROM SAPSECDB.VIRSA_CC_ALLISTDTL

DELETE FROM SAPSECDB.VIRSA_CC_ALTCDLOG

DELETE FROM SAPSECDB.VIRSA_CC_AUTHMAP

DELETE FROM SAPSECDB.VIRSA_CC_CRACT

DELETE FROM SAPSECDB.VIRSA_CC_CRACTT

DELETE FROM SAPSECDB.VIRSA_CC_CRPRM

DELETE FROM SAPSECDB.VIRSA_CC_CRPROF

DELETE FROM SAPSECDB.VIRSA_CC_CRPROFT

DELETE FROM SAPSECDB.VIRSA_CC_CRROLE

DELETE FROM SAPSECDB.VIRSA_CC_CRROLET

DELETE FROM SAPSECDB.VIRSA_CC_DATAEXD

DELETE FROM SAPSECDB.VIRSA_CC_FLDMAP

DELETE FROM SAPSECDB.VIRSA_CC_FUNCACT

DELETE FROM SAPSECDB.VIRSA_CC_FUNCPRM

DELETE FROM SAPSECDB.VIRSA_CC_FUNCSYS

DELETE FROM SAPSECDB.VIRSA_CC_LASTRUN

DELETE FROM SAPSECDB.VIRSA_CC_LSYSGRP

DELETE FROM SAPSECDB.VIRSA_CC_ORGUSERS

DELETE FROM SAPSECDB.VIRSA_CC_PRMRULE

DELETE FROM SAPSECDB.VIRSA_CC_SUPP_DET

DELETE FROM SAPSECDB.VIRSA_CC_SUPP_HDR

DELETE FROM SAPSECDB.VIRSA_CC_SUPP_TEXT

DELETE FROM SAPSECDB.VIRSA_CC_SYSCRACT

DELETE FROM SAPSECDB.VIRSA_CC_SYSHMAP

DELETE FROM SAPSECDB.VIRSA_CC_SYSRULE

DELETE FROM SAPSECDB.VIRSA_CC_SYSSAPOBJ

DELETE FROM SAPSECDB.VIRSA_CC_SYSUSR

DELETE FROM SAPSECDB.VIRSA_CC_TEXTKEY

DELETE FROM SAPSECDB.VIRSA_CC_USRMAP

DELETE FROM SAPSECDB.VIRSA_CC_XSRULEMAP

DELETE FROM SAPSECDB.VIRSA_CC_XSYSGRP

DELETE FROM SAPSECDB.VIRSA_CC_SYSTEM

DELETE FROM SAPSECDB.VIRSA_CC_SYSTEMC

DELETE FROM SAPSECDB.VIRSA_CC_SYSTEMT