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 176: 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. |
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
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.
To assign a change label in the Schema Extension
For detailed information about working with change labels, see the One Identity Manager Operational Guide.
