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 see the United States Patient Solution template, go to https://open-dm-mi.dev.java.net/docs/solutions/usa-patient.html.
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.
As a SYSDBA user run the createuser-usa.sql script.
As the usa user, with a password of usa, run the following scripts.
Run the create.sql script first.
create.sql
codelist.sql
systems.sql
createIndexes.sql
createUserCodeData.sql