Identity Manager 8.1 - Configuration Guide

Creating indexes

Define indexes to optimize access to database columns. An index can contain one or more database columns.

To create a new index in the Schema Extension

1. Open Launchpad and select One Identity Manager Schema Extension. This starts the Schema Extension program.
2. Click Next on the start page.
3. On the Database connection page, enter the connection credentials for the One Identity Manager database.
4. On the Select method page, select Create index
5. On the Extend Table page, choose Table and select the table for which you want to create an index.
6. On the Create index page, define the columns for the index definition.
   1. Click the button.

      This opens a dialog box where you can define the columns for the index. You can see all the columns in the table on the right-hand side of the dialog window. The columns on the left-hand side of the window belong to the index.

   2. Enter the name of the index in the Index name input field.

      A name is already suggested. You can change this as required.

   3. Select the column you want to add to the index on the right-hand side of the dialog window.
   4. Using , add the column to the index.

      Change the order of the column in the index definition if you want or remove a column from the index with the appropriate button.

   5. Click OK.

Removing custom schema extensions

You can only delete custom schema extensions on databases with the staging level Test environment or Development system.

1. Open Launchpad and select Extend the One Identity Manager schema. This starts the Schema Extension program.

2. Click Next on the start page.

3. On the Database connection page, enter the connection credentials for the One Identity Manager database.

4. On the Select method page, select Remove extensions.

5. On the Remove extensions page, select the custom schema extension that you want to remove.

6. To remove a custom table, select the table in the Table list and enable the Remove whole table option.

7. To remove custom columns, select the table in the Table list and select the columns under Columns to remove.

8. Click Next.

9. Confirm the security prompt with Yes.

10. Changes to the schema are displayed on the page System modifications. For more information, see Applying the schema extensions.

Permissions for schema extensions

Select the permissions groups that have permissions for the schema extensions. This make initial access to the schema extensions possible with One Identity Manager administration tools.

To specify permissions groups in the Schema Extension

• On the Permissions page, use the menus to select

  • at least one custom permissions group that has read and write access
  • at least one custom permissions group that has read access only

Once you have committed all changes to the database, you can assign additional permissions using the Permissions Editor in the Designerprogram. For more detailed information, see the One Identity Manager Authorization and Authentication Guide.

Change labels for the schema extensions

Assign a change label to the schema extensions. Change labels are offered as export criteria in the Database Transporter when you create a customer transport package. For detailed information about working with change labels, see One Identity Manager Operational Guide.

To assign a change label in the Schema Extension

• On the Define change label page, choose one of the following options.
  • No change label
  • Add new change label: In the Change label box, enter the name of the change label.
  • Use existing change label: select a change label from the Change label menu.