Creating User Roles that Can Define News Items Only

By default, any user with one of the following roles can perform all RDC administrative tasks, including the task of defining news items:

• RXC_ADMIN
• RXC_SUPER
• RXC_SUPER_NOGL
• RXC_DES
• RXC_DMGR

You can also create a different set of roles with limited administrator privileges. For example, you can grant a user the privilege to define news content only. Granting others this one privilege makes it easy to update daily and site-specific news.

Note that the process you use to create the user roles that have privileges to define news content is different from the process for creating the user roles for other administrative privileges. Therefore, you can identify user roles for defining news content that are different from the roles for performing other administrative tasks.

To create or modify the set of user roles that can define news items only:

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 admin_user function.
   • Add the roles that you want to have privileges to define news items.
   • Delete any roles you do not want to have the ability to define news items.
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.