Article

Francesco Vinci's picture
article
Reads:

3600

Score:
3
3
2
 
Comments:

0

Using an IDM Rule to Track Attribute Changes in Oracle DB

Author Info

3 January 2007 - 2:51am
Submitted by: Francesco Vinci

Author Blog
Author Profile

Tags

Tags Map

(View Disclaimer)

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

Disclaimer: As with everything else at Cool Solutions, this content is definitely not supported by Novell (so don't even think of calling Support if you try something and it blows up).

It was contributed by a community member and is published "as is." It seems to have worked for at least one person, and might work for you. But please be sure to test, test, test before you do anything drastic with it.



Related Articles


User Comments

© 2013 Novell