Chat now with support
Chat with Support

Identity Manager 9.1.2 - Configuration Guide

About this guide One Identity Manager software architecture Customizing the One Identity Manager default configuration Customizing the One Identity Manager base configuration One Identity Manager schema basics Editing the user interface
Object definitions for the user interface User interface navigation Forms for the user interface Statistics in One Identity Manager Extending the Launchpad Task definitions for the user interface Applications for configuring the user interface Icons and images for configuring the user interface Using predefined database queries
Localization in One Identity Manager Process orchestration in One Identity Manager
Mapping processes in One Identity Manager Setting up Job servers
The One Identity Manager Service functionality Tracking changes with process monitoring Conditional compilation using preprocessor conditions Scripts in One Identity Manager
Visual Basic .NET scripts usage Notes on message output Notes on using date values Tips for using Windows PowerShell scripts Using dollar ($) notation Using base objects Calling functions Pre-scripts for use in processes and process steps Using session services Using #LD-notation Script library Support for processing scripts in the Script Editor Creating and editing scripts in the Script Editor Copying scripts in the Script Editor Testing scripts in the Script Editor Testing script compilation in the Script Editor Overriding scripts Permissions for running scripts Editing and testing script code with the System Debugger Extended debugging in the Object Browser
One Identity Manager query language Reports in One Identity Manager Adding custom tables or columns to the One Identity Manager schema Web service integration One Identity Manager as SCIM 2.0 service provider Processing DBQueue tasks One Identity Manager Service configuration files

Creating indexes

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

NOTE: For tables that you create using the Schema Extension program, indexes are automatically created for the primary key column and the object key column (XObjectKey).

To create a new index in the Schema Extension

  1. Start the Launchpad and log in to the One Identity Manager database.

  2. Open the Launchpad and select the One Identity Manager Schema Extension entry. This starts the Schema Extension program.

  3. Click Next on the start page.

  4. On the Database connection page, check the connection credentials for the One Identity Manager database.

  5. On the Select method page, select Create index

  6. On the Extend Table page, under Table, select the table for which you want to create an index.

  7. 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. On the right-hand side of the dialog window, select the column you want to add to the index.

    4. Use the button to add the column to the index.

      Change the order of the columns in the index definition as required or remove a column from the index using the relevant button.

    5. Click OK.

Removing custom schema extensions

NOTE: You can delete custom schema extensions only on databases with the Test environment or Development system staging level. It is not possible to transport the changes.

To remove custom schema extensions in the Schema Extension

  1. Start the Launchpad and log in to the One Identity Manager database.

  2. Open the Launchpad and select the One Identity Manager Schema Extension entry. This starts the Schema Extension program.

  3. Click Next on the start page.

  4. On the Database connection page, check the connection data for the One Identity Manager database.

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

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

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

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

  9. Click Next.

  10. Confirm the security prompt with Yes.

  11. Changes to the schema are displayed on the System modifications page. For more information, see Adding schema extensions to the database.

Related topics

Possible error messages due to custom schema extensions

Error messages that arise when you delete schema extensions are displayed in the Schema Extension and logged in the system journal.

Table 177: Possible error messages

Step

Message

Solution

Checking Table empty

Table is not empty

Remove all objects from the table before you run the schema modification.

Checking template references

Column is referenced in template <TableName>.<ColumnName>

In the Designer, change all templates and formatting scripts that refer to the columns you want to delete.

For more information, see Editing value templates and Creating formatting scripts.

Checking referential integrity

Column is referenced as parent in RI <RelationID>

Remove all table relations from the QBMRelation table before you run the schema modification.

Checking dynamic RI

Column is referenced as parent in <TableName>.<ColumnName>

The column you want to delete is defined as a target for dynamically referenced tables. Use the Designer to resolve the reference.

For more information, see Dynamic foreign key.

Checking indexes

Column is contained in index <TableName>.<IndexName>

Before you run the schema modification, change or delete the index so that the column is not referenced anymore.

Permissions for schema extensions

NOTE: At database level, the End user role database role is permitted for custom schema extensions.

For initial access to the schema extensions using One Identity Manager tools, select the permissions groups that contain the permissions for the schema extensions. After you have committed all the changes in the database, you can grant additional permissions through the Permissions Editor in the Designer. For more information, see the One Identity Manager Authorization and Authentication Guide.

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

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating