Oracle® Identity Manager Connector Guide for BMC Remedy User Management Release 9.0.1 Part Number B31111-01 |
|
|
View PDF |
To create a database trigger for moving all deleted users from the SHR:People form to the SHR:DeletePeople form, perform the following steps:
Log in to SQL*Plus.
Copy the following script at the SQL prompt:
CREATE or REPLACE TRIGGER trig1 AFTER DELETE ON t57 FOR EACH ROW BEGIN INSERT INTO t608 (C1,C2,C3,C4,C5,C6,C7,C8,C102,C109,C115,C179, C100000106,C100000113,C100000120,C100000121,C100000122, C200000006,C200000007,C200000012,C230000009,C240000001, C240000003,C240000004,C240000005,C240000006,C240000007, C240000008,C240000009,C240000010,C240000011,C240000035, C240000036,C240000037,C240000038,C240000040V,C240000040C, C240000040D,C240000040USD,C240000040EUR,C240000040GBP, C240000040JPY,C240000041,C240000042,C260000000,C260000001, C260000002,C260000003,C260000004,C260000005,C260000006, C260000008,C260000009,C260000010,C260000026,C261000002, C261000008,C261000009,C261000010,C261000011,C300469200, C300469300,C300495800,C300787900) VALUES (:old.C1,:old.C2,:old.C3,:old.C4,:old.C5,:old.C6, :old.C7,:old.C8,:old.C102,:old.C109,:old.C115,:old.C179, :old.C100000106,:old.C100000113,:old.C100000120, :old.C100000121,:old.C100000122,:old.C200000006, :old.C200000007,:old.C200000012,:old.C230000009, :old.C240000001,:old.C240000003,:old.C240000004, :old.C240000005,:old.C240000006,:old.C240000007, :old.C240000008,:old.C240000009,:old.C240000010, :old.C240000011,:old.C240000035,:old.C240000036, :old.C240000037,:old.C240000038,:old.C240000040V, :old.C240000040C,:old.C240000040D,:old.C240000040USD, :old.C240000040EUR,:old.C240000040GBP,:old.C240000040JPY, :old.C240000041,:old.C240000042,:old.C260000000, :old.C260000001,:old.C260000002,:old.C260000003, :old.C260000004,:old.C260000005,:old.C260000006, :old.C260000008,:old.C261000009,:old.C260000010, :old.C260000026,:old.C261000002,:old.C261000008, :old.C261000009,:old.C261000010,:old.C261000011, :old.C300469200,:old.C300469300,:old.C300495800, :old.C300787900); end; /
Run the script.