7 Database Schema Password Manager

The Database Schema Password Manager is used to:

• Migrate schema entries to the latest encryption.

• Change schema passwords to allow the ownership of passwords to be with the customers.

• Add new schema entries.

Migrating Schema Entries to the Latest Encryption

Schema Migration is the first tab of the Database Schema Password Manager. This tab is used to migrate the Non-PADSS or OLD PADSS encrypted password entries to the most recent encryption; therefore, the tab is only enabled if an entry is using OLD PADSS or NON PADSS encryption. If the schema has all entries on the latest encryption, this tab is not enabled.

To migrate schema entries to the latest encryption:

1. Enter and save OHCFMSSecurityService.url and AdminModeDataSource (data source name) in the FCDBPassword.config file.
2. Click the Schema tab, and then enter the following information:
   • System User: Enter the database system user name.
   • System Password: Enter the system user password.
   • Schema Name: Enter the schema name.
   • Schema Password: Enter the new password for the schema.
3. Click the Migration button to proceed.
4. Click OK to complete the migration.

   Figure 7-1 Schema Migration tab in the Database Schema Password Manager screen

   
   
   

Changing Schema Passwords

The Change Password is the second tab of the Database Schema Password Manager. This tab is used to provide ownership of passwords to customers.

To change a schema password:

1. On the Database Schema Password Manager screen, select a schema you wish to change the password.
2. Click the Change Password tab, and then enter the following information:

   • System User: Enter the database system user name.

   • System Password: Enter the system user password.

   • Schema Name: This is automatically populated with the schema name and is greyed out.

   • Schema Password: Enter the new password for the schema.

   • Expiry Date: Enter the new expiration date.

3. Click Save to complete the password change.

   Figure 7-2 Change Password tab in the Database Schema Password Manager screen

   
   
   

Adding a Schema Entry

Add Schema is the third tab of the Database Schema Password Manager. This tab is used to add a new schema entry to the FIDELIOBK schema.

To add a new schema entry:

1. Click the Add Schema tab, and then enter the following information:

   • System User: Enter the database system user name.

   • System Password: Enter the system user password.

   • Schema Name: Enter the name for the new schema entry.

   • Schema Password: Enter the password for the new schema.

   • Expiry Date: Enter the expiration date.

   Note:

   The latest encryption key is used for new entries.
2. Click Add User to complete the addition of a new schema entry.

Figure 7-3 Add Schema tab in the Database Schema Password Manager screen