Setting Up Data Extract Users

Oracle Clinical users who need to generate Data Extract views and write macros need a table in their individual user's schema that provides a location to save the SQL code the user creates using data extract functions.

Oracle provides a script, crusrq.sql, that creates a table called USER_QUERIES in an individual user's schema. Run the script for each user who will write data extract functions.

To create this table:

1. Change directories to the RXC_INSTALL directory.

2. Run this command:

   sqlplus @crusrq
   

Alternatively, you can modify the Add User script to create the USER_QUERIES table automatically by adding these lines:

connect &&ops_id/&&pwd
@rxc_install:crusrq.sql