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:
-
Change directories to the RXC_INSTALL directory.
-
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
Parent topic: Setting Up User Accounts