Set Up the opapps User Account and oclsascr User Group

Before you install Oracle Clinical database server, create the following user group and account:

  • oclsascr — The group that controls access to the files Oracle Clinical generates for SAS
  • opapps — The operating system account that owns Oracle Clinical and that runs the Parameterized Submission (PSUB) process.

For more information, see:

Create the oclsascr User Group for SAS

If you use SAS integrated with Oracle Clinical, you must create the oclsascr user group, which controls access to the files Oracle Clinical generates on the database server for SAS. These include SAS data extract files, which contain patient data.

  1. Create a user group named oclsascr by adding it to the /etc/group file.
  2. The preferred method for group authentication is that all groups assigned to a user should become the user's default group at login. If this method is acceptable, link the /etc/logingroup file to the /etc/group file.
    • If the /etc/logingroup file does not exist, create it as a symbolic link to the /etc/group file; changes in the /etc/group file automatically reflect in the /etc/logingroup file.

      To create the symbolic link, enter these commands:

      % su root
      # cd /etc
      # ln -s /etc/group /etc/logingroup
      
    • If the /etc/logingroup file already exists with entries, or if it is unacceptable to link it to the /etc/group file, you must change both the contents of /etc/logingroup and /etc/group each time you add a user to the oclsascr group.

Create the opapps Account and Add It to Groups

Create the opapps operating system account that owns Oracle Clinical. This account also has the privileges to run the parameterized submission (PSUB) service RXCPSDPS and the PSUB Launcher (PSLAUNCH). The opapps home directory on the database server, for example /pharm/home/opapps, is referred to as OPA_HOME in Oracle Clinical documentation.

  1. Make a shell for this user. For example, make the default shell:

    /bin/csh

  2. Make the opapps account a member of these user groups:
    • oclsascr
    • oinstall
    • dba

    Neither oclsascr nor oinstall group needs to be the primary group for the opapps account.