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
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.
A name is already suggested. You can change this as required.
Change the order of the column in the index definition if you want or remove a column from the index with the appropriate button.
You can only delete custom schema extensions on databases with the staging level Test environment or Development system.
Open Launchpad and select Extend the One Identity Manager schema. This starts the Schema Extension program.
Click Next on the start page.
On the Database connection page, enter the connection credentials for the One Identity Manager database.
On the Select method page, select Remove extensions.
On the Remove extensions page, select the custom schema extension that you want to remove.
To remove a custom table, select the table in the Table list and enable the Remove whole table option.
To remove custom columns, select the table in the Table list and select the columns under Columns to remove.
Confirm the security prompt with Yes.
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
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.
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