Creating a Database for the United Kingdom Patient Solution

This topic provides an example on how to create a user called uk. To create a different user, edit the createuser-uk.sql file. For links to instructions on the various tasks when setting up your healthcare solution, see United Kingdom Patient Solution Uses.

To Create a Database for the United Kingdom Patient Solution

Before You Begin

The Oracle scripts that come with the solution create a user identified as uk. They are located in the Solutions\NB\MI\project\UKPatient\sca\source\DatabaseScript directory.

1. As a SYSDBA user run the createuser-uk.sql script.
2. As the uk user, with a password of uk, run the following scripts.

   ---

   Tip - Run the create.sql script first.

   ---

   • create.sql

   • codelist.sql

   • systems.sql

   • createIndexes.sql

   • createUserCodeData.sql