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