SSOQ
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
IDM_STAGING.ST_TRIGGER_ROLE_PROV_ACTION
Parameters
Name
Type
Mode
Definition
TRIGGER IDM_STAGING.ST_TRIGGER_ROLE_PROV_ACTION AFTER UPDATE ON IDM_STAGING.ROLE_PROVISIONING FOR EACH ROW WHEN (NEW.active != OLD.active) BEGIN IF (:NEW.active = 1) THEN INSERT INTO IDM_STAGING.AUXILIARY_ACTION VALUES ('','ROLE_PROVISIONING','ENABLE',:NEW.object_ID); ELSE INSERT INTO IDM_STAGING.AUXILIARY_ACTION VALUES ('','ROLE_PROVISIONING','DISABLE',:NEW.object_ID); END IF; END;