How do I import 'User-Defined' triggers from one Oracle instance to another with VigilEnt Audit Mana (NETIQKB33462)

  • 7733462
  • 02-Feb-2007
  • 08-Sep-2008

Resolution

goal
How do I import 'User-Defined' triggers from one Oracle instance to another with VigilEnt Audit Manager for Oracle?

fact
VigilEnt Audit Manager for Oracle 4.0x

fact
VigilEnt Security Agent for Oracle 1.x

fix

Refer to the following steps for importing user-defined triggers:

  1. Start or launch the Audit Manager console for the instance that will receive these new User-defined triggers.
  2. Choose the menu option Audit Options/User Defined.
  3. Select the icon with a pointing hand. The Importing User Defined Audit configuration window will pop-up.
  4. Enter a privileged username (SQLCQR) and password for the database on which the triggers are currently stored. Then select the Next Step button.
  5. Select the trigger(s) to be imported. Use either the individual checkbox found in the Import column or the Select All button. Then, select the Next Step button.
  6. Click on the Import selected User-Defined Audit configurations button. When the import finishes it will display a success or failure message with the number of triggers imported.
  7. Highlight the newly imported trigger and press the diskette icon to save and enable this user-defined trigger.

    Note: This process requires VigilEnt Audit Manager for Oracle to be installed on both Oracle database instances.



Additional Information

Formerly known as NETIQKB33462