Novell Home

Using an IDM Rule to Track Attribute Changes in Oracle DB

Novell Cool Solutions: Tip
By Francesco Vinci

Digg This - Slashdot This

Posted: 3 Jan 2007
 

Problem

You want to use a rule in Command Transformation Policy to change specific fields in the Oracle database SQL. If the functions 'if-src-attr' and 'Destination Attribute' are used, then the Remote Loader does not connect to the driver, and the following error occurs:

"java.lang.SecurityException: Authentication handshake failed: driver returned 'Invalid driver object password'"

Solution

To diagnose changes in specific fields in the database, use this function:

"if operation attribute 'Surname' changing"

Example

<rule>
<description>Rinomina</description>

<comment name="author" xml:space="preserve">Francesco Vinci</comment>
<conditions>
<and>
<if-op-attr name="CN" op="changing"/>
</and>
</conditions>
<actions>
<do-rename-dest-object>
<arg-string>
<token-attr name="CN"/>
</arg-string>
</do-rename-dest-object>
</actions>
</rule>

Environment

  • Open Enterprise Server SP2
  • Identity Manager 3.0.1
  • Windows Server 2003 with:
    • Oracle 9i
    • Remote Loader: IDM 3.0.1 JDBC Driver Version 2.1.5


Novell Cool Solutions (corporate web communities) are produced by WebWise Solutions. www.webwiseone.com

© 2014 Novell