Mitigating control - download and upload feature

150 Views

Hello !

I am trying to abuse the mitigating control feature in order to reduce the hits, as access control lacks the feature that it is ok and confirmed that a user has certain critical transactions in his role.

Anyway, as the definition on the web frontend is quite time-consuming, I tried it with the download and upload feature. It also works fine, unless it comes to table VIRSA_CC_MITROLE which includes DATE values.

At that point the file looks like the following:

M VIRSA_CC_MITROLE MITREFNO RISKID ROLEID VALIDFROM VALIDTO MONITORID STATUS

D VIRSA_CC_MITROLE FI_01 F100 ABCDE 15.03.2011 14.03.2012 XYZ 0

This results in the following error:

SQL:=>Insert into VIRSA_CC_MITROLE(MITREFNO,RISKID,ROLEID,VALIDFROM,VALIDTO,MONITORID,STATUS ) Values(?,?,?,?,?,?,?)

Aufzeichnen::Line Number :37 : D VIRSA_CC_MITROLE FI_01 F100 ABCDE 15.03.2011

The last line stops at the FIRST date value.

I also tried to execute the following statement in the CCDebugger, but it didn't work:

Insert into VIRSA_CC_MITROLE(MITREFNO,RISKID,ROLEID,VALIDFROM,VALIDTO,MONITORID,STATUS ) Values('FI_01','F100','ABCDE','20110315','20120314','XYZ',0);

I also tried without ' regarding the date values and with 20110315 and 2011-03-15 but it didn't help:

contains the semantics error[s]: - type check error: new value (element number 4 (CHAR)) is not assignable to column >>VALIDFROM<< (DATE) - type check error: new value (element number 5 (CHAR)) is not assignable to column >>VALIDTO<< (DATE)

Does any have a solution for this issue ?

Kind regards,

Max