About the Sample Database Scripts

Identity Manager provides sample database scripts that you can modify and use to create tables and indexes. You may choose to use an alternate method to create equivalent tables and indexes, but these requirements must be met:

• Tables (or views) must exist with the names specified in the sample DDL

• Each named table (or view) must be owned by (or aliased to) the proxy user that is represented as “waveset” in the sample DDL

• Each named table (or view) must contain all the columns specified for that table in the sample DDL

• Each named column must have a data type that is consistent with the data type specified for that column in the sample DDL

You can modify the sample scripts to suit your environment.

Common changes include:

• Specifying a different proxy user

• Specifying different tablespaces, or separate tablespaces for tables and indexes

• Changing a data type. This is acceptable if a view or the JDBC driver makes the change transparent.

• Adding columns. This is acceptable if each column is nullable or defaulted.

• Removing or renaming columns. This is acceptable if a view makes this transparent.

• Renaming indexes

If you make changes to the sample scripts, then you must make equivalent changes to any sample database upgrade scripts that you receive in the future.