how to launch role owner certification on basis of sox critical

[Dharmen]

Hi Team,

We are trying to launch role owner certification for the SOX Critical medium and high.

We don't see any option for this and when we are trying to achieve with Role Query we are not able to get the correct query or it shows SQL syntax error.

Please let us know what we should we use to filter the SOX critical for role owner certifications. 

Thanks,

Dharmen

[sk]

try sox_critical in (3,4) for including Medium and High respectively

[Dharmen]

I have tried this its not working

[dgandhi]

Hi Dharmen,

Can you try below and check?

and ro.rolekey.SOX_CRITICAL in (3,4)

We used CP2 and it did worked so similarly you can try for SOX_CRITICAL field.

Thanks

Devang

[Dharmen]

Thanks Devang,

I have tried but its shows syntax error.

[Dharmen · Accepted solution]

We need to use in below format

and ro.rolekey.soxcritical in (3,4)

Its working fine now.

Thanks,