Identity Manager 8.0 - Configuration Guide

Creating New Assignments Tables

To create a new assignment (many-to-many) table in the Schema Extension.

1. Open Launchpad and select One Identity Manager Schema Extension. This starts the program "Schema Extension".
2. Click Next on the start page.
3. Enter connection credential for the One Identity Manager database on the Database connection page and click Next.
4. Select the extension method New relation table on the Extension method page and click Next.
5. Enter the properties for the assignment table on the Create a relation table page and click Next.

   Table 316: Assignment Tables Properties

   Property	Description
   Table	Name of the table. The name of the new table must begin with the prefix "CCC". The table name is formatted as CCC<table name>.
   Display name	The display name is used, for example, to identify the table in a database search or for error output.
   Description	You can enter a comment on a table about using it in the data model.
   Create XOrigin column (for assignment requests)	You can create the origin column (XOrigin) optionally. The origin of an assignment is stored in this column as a bit field. Each time an entry is made in the assignment table the bit position is changed according to the assignment type.
   Related tables	Use Left table and Right table to specify which tables are involved in the relation table.
   Column names	Enter the relevant columns in Column name for each side of the table. Select the table’s primary key column.

   NOTE: Table and column relations are created automatically.

6. Next step: You define the column properties on the Configure columns page. For more information, see Configuring Column Properties.

   NOTE: The columns XObjectKey and XMarkedForDeletion are created automatically.

Related Topics

• Creating a New Table
• Creating a Read-Only Database View
• Creating a Union View
• Mapping Table Definitions

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 program "Schema Extension".
2. Click Next on the start page.
3. Enter connection credential for the One Identity Manager database on the Database connection page and click Next.
4. Select the extension method New index on the Extension method page and click Next.
5. On the Extend table page, select the table for which you want to create an index and click Next.
6. Specify the columns for the index definition on the Create index page and click Next.
   1. Click .

      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 index name in Index name.

      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. Add the column to the index using the add button, .

      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. Confirm with OK.
7. Next step: Assign the schema extension to a change label on the Define change label page. For more information, see Specifying Change Labels for Schema Extensions.

Permissions for Schema Extensions

Specify the permissions group to be given permissions for the schema extension. This make initial access to the schema extensions possible with One Identity Manager administration tools.

You can allocate more permissions with the Permissions Editor in the Designer after these changes have been made in the database.

To specify permissions groups in the Schema Extension

1. Select the permissions groups to obtain permissions for the schema extensions on the page, Access permissions.

   Use the menus to select:

   • Permissions groups with read and write permissions
   • Permissions groups which are only read-only
2. Next step: Assign the schema extension to a change label on the Define change label page. For more information, see Specifying Change Labels for Schema Extensions.

Related Topics

• Editing Permissions for One Identity Manager Schema Tables and Columns

Specifying Change Labels for Schema Extensions

Select a change label under which your schema extension will be grouped. The change labels appear as export criterion in the program "Database Transporter" when a customer transport packet is set up.

To assign a change label in the Schema Extension

1. Assign the schema extension to a change label on the Define change label page.

   These options are available:

   • No change label
   • Add new change label

     Enter the name of the change label in Change label.

   • Use existing change label

     Select a change label from the Change label list.

2. Next step: The schema extensions are displayed on the Schema modifications page. You can export the extensions to file. For more information, see Adding Schema Extensions.

Related Topics

• Working with Change Labels