Creating User Roles that Can Upgrade DCI Forms Only

By default, users with the role RXC_ADMIN, RXC_SUPER, or RXC_SUPER_NOGL can upgrade the DCI forms that RDC uses for HTML data entry and for the Patient Data Reports.

Note that the process you use to create the user roles that have access to the DCI Forms Upgrade utility is different from the process for creating the user roles for other administrative privileges. Therefore, you can identify user roles for upgrading DCI forms that are different from the roles for performing other administrative tasks.

To modify the set of roles that have privileges to upgrade DCI forms:

1. Log in to the Oracle Clinical database server.
2. Navigate to the Oracle Clinical INSTALL directory.
3. Open the opapb_level_privs_m1.sql file with a text editor.
4. Find the dcif_upgrade_user function.
   • Add the roles that you want to have privileges to upgrade DCI Forms.
   • Delete any roles you do not want to have the ability to upgrade DCI Forms.
5. Connect to SQL*Plus.
6. Run the SQL script to process your changes:

   START opapb_level_privs_m1.sql

Note:

Oracle supports this modification, but you are responsible for re-applying any modification if a patch overrides the package.