SSOQ
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
IDM_STAGING.ST_TRIGGER_ROLE_PROV_ADD
Parameters
Name
Type
Mode
Definition
TRIGGER IDM_STAGING.ST_TRIGGER_ROLE_PROV_ADD AFTER INSERT ON IDM_STAGING.ROLE_PROVISIONING FOR EACH ROW WHEN (NEW.active = 1 ) BEGIN INSERT INTO IDM_STAGING.AUXILIARY_ACTION VALUES ('','ROLE_PROVISIONING','ADD',:NEW.object_ID); END;