Access Accounts

In creating a clinical study state for a study (from the Conduct menu, select Security, then select Clinical Study States), you automatically create access accounts. These accounts are owned by one of the following kinds of account — Current, Stable, Rollsnap or Test. The only accounts you can create are Snapshot accounts.

The Oracle account name is the name of the study concatenated with $, concatenated with the account type. Snapshot accounts follow the naming convention of Study$your_choice_of_name. your_choice_of_name should not include any special characters including a '.' or '_' in the string, as this may cause issue with other features/functionality. When you run the PSUB form Maintain Data Extract Views, you run your job in one of the account types described in order to create the view.

You cannot log on to these accounts, but you can describe and select from the views, if you have the appropriate security, by logging on to SQL*Plus in your own account, and typing — for example:

desc ORACLIN$SNAPSHOT1

SAS views are created on the server, in the RXC_SAS_VIEW directory, with this structure: a subdirectory for each database, then study, then account type — for example:

RXC_SAS_VIEW/database5002/study12345/current

A subdirectory is created for each new Snapshot or Rollsnap account — for example:

RXC_SAS_VIEW/database5002/study12345/snap

The RXC_SAS_VIEW path is set by the Administrator as an Oracle Clinical environment variable.

For more information see:

• Purging Study Access Accounts