Technical details
-
The technical identifier for the table is automatically formed according to the schema CCC<Table name>.
-
The XObjectKey and XMarkedForDeletion columns are automatically generated.
-
The table relations and column relations are generated automatically.
To create a new assignment (many-to-many) table in the Schema Extension.
-
Start the Launchpad and log in to the One Identity Manager database.
-
Open the Launchpad and select the One Identity Manager Schema Extension entry. This starts the Schema Extension program.
-
Click Next on the start page.
-
On the Database connection page, check the connection data for the One Identity Manager database.
-
On the Select method page, select New relation table.
-
On the Create a relation table page, enter the following information.
Table 176: Assignment table properties
|
Table |
A technical name for the table. |
|
Display name |
Displays table name The display name is used, for example, to identify the table in a database search or for error output. |
|
Description |
Comments on using the table. |
|
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 the Left table and Right table menus to specify which tables are included in the relation table. |
|
Column names |
In Column name fields, enter the relevant columns for each side of the table. Select the table’s primary key column. |
-
On the Configure columns of table page, enter display names for the columns.
-
(Optional) Click 
to configure more column properties. For more information, see Advanced configuration of columns.
Related topics
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
-
Start the Launchpad and log in to the One Identity Manager database.
-
Open the Launchpad and select the One Identity Manager Schema Extension entry. This starts the Schema Extension program.
-
Click Next on the start page.
-
On the Database connection page, check the connection credentials for the One Identity Manager database.
-
On the Select method page, select Create index
-
On the Extend Table page, under Table, select the table for which you want to create an index.
-
On the Create index page, define the columns for the index definition.
-
Click the 
button.
This opens a dialog where you can define the columns for the index. You can display 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.
-
Enter the name of the index in the Index name input field.
A name is already suggested. You can change this as required.
-
On the right-hand side of the dialog window, select the column you want to add to the index.
-
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.
-
Click OK.
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
-
Start the Launchpad and log in to the One Identity Manager database.
-
Open the Launchpad and select the One Identity Manager Schema Extension entry. This starts the Schema Extension program.
-
Click Next on the start page.
-
On the Database connection page, check the connection data 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.
-
Click Next.
-
Confirm the security prompt with Yes.
-
Changes to the schema are displayed on the System modifications page. For more information, see Adding schema extensions to the database.
Related topics
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
|
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. |
