We are in the stylesheet Sub-Clock for a clock tick
Unable to tick clock.
Missing 'currenttime' value or wrong clock.
We are in the stylesheet Sub-Clock for processing a clock tick
Create fake user events in eventlog
INSERT INTO IDM.EVENTLOG
(record_id, event_type, perpetrator, table_name, table_key)
SELECT IDM.SEQ_RECID.nextval, 5, 'fake', 'VIEW_ORCLUSERS', 'pk_USERNAME=' || pk_USERNAME FROM VIEW_ORCLUSERS WHERE pk_USERNAME LIKE 'TEST%'
AND 'pk_USERNAME=' || pk_USERNAME NOT IN (SELECT table_key FROM IDM.EVENTLOG WHERE statusnbsp = 'S')
Create fake role events in eventlog
INSERT INTO IDM.EVENTLOG
(record_id, event_type, perpetrator, table_name, table_key)
SELECT IDM.SEQ_RECID.nextval, 5, 'fake', 'VIEW_ORCLROLES', 'pk_ROLE=' || pk_ROLE FROM VIEW_ORCLROLES
WHERE 'pk_ROLE=' || pk_ROLE NOT IN (SELECT table_key FROM IDM.EVENTLOG WHERE statusnbsp = 'S')
Create fake priv events in eventlog
INSERT INTO IDM.EVENTLOG
(record_id, event_type, perpetrator, table_name, table_key)
SELECT IDM.SEQ_RECID.nextval, 5, 'fake', 'VIEW_ORCLPRIVS', 'pk_GRANTEE=' || pk_GRANTEE || '+pk_GRANTED_ROLE=' || pk_GRANTED_ROLE FROM VIEW_ORCLPRIVS WHERE (pk_GRANTEE LIKE 'TEST%' OR pk_GRANTEE LIKE 'ROLE%')
AND 'pk_GRANTEE=' || pk_GRANTEE || '+pk_GRANTED_ROLE=' || pk_GRANTED_ROLE NOT IN (SELECT table_key FROM IDM.EVENTLOG WHERE statusnbsp = 'S')