Creating a Database for the United States Patient Solution

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

To Create a Database for the United States Patient Solution

Before You Begin

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

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

   ---

   Tip - Run the create.sql script first.

   ---

   • create.sql

   • codelist.sql

   • systems.sql

   • createIndexes.sql

   • createUserCodeData.sql