To create a new assignment (many-to-many) table in the Schema Extension.
|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.
NOTE: The columns XObjectKey and XMarkedForDeletion are created automatically.
Define indexes to optimize access to database columns. An index can contain one or more database columns.
NOTE: Tables that you create with the program "Schema Extension" are automatically indexes for primary key columns and the object key column (XObjectKey).
NOTE: Creating bitmap indexes is not supported under Oracle by the program "Schema Extension". It is not recommended to generate bitmap indexes manually.
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.
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
Use the menus to select:
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
These options are available:
Enter the name of the change label in Change label.
Select a change label from the Change label list.