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