Maintaining Oracle User and Group User Accounts

After you create a user with the Add User script, the user account appears in the Oracle Accounts window. Use this window to:

• Create group user accounts for users who should have access to the same set of studies, programs, or projects in order to assign data access to all the users at the same time1. A user can belong to multiple group user accounts.
• View and modify settings for individual user accounts

  Note:

  Do not use this window to create new individual user accounts because you cannot assign database roles to users here. Use the Add User script.

You can access other windows from Oracle Accounts to do the following tasks:

• Adding a User to a Group User Account; use this window to assign a user to a group user account. You can then grant data access to all the users assigned to the group user account at the same time.
• Granting Data Access to a Study; use this window to grant access to one study at a time to a single user or group user account
• Granting Data Access to Programs and Projects; use this window to grant a access to all the studies in a program or project at the same time to a single user or group user account

To create a group user account:

1. From the Data menu, select Insert Record.
2. Enter values in the fields.

The window contains the following fields:

Account Type - If set to Oracle, the record is an individual user account. To create a group user account, set to Group.

Account Name - For an individual user account, the user ID; for a group user account, its name.

Last Name - Family name or surname of the user with the individual user account; not required for group user accounts.

First Name - Given name of the user with the individual user account; not required for group accounts.

Super User? - If checked, the user or group user account has superuser status and can see data in all studies on the database. If not checked, the user or group user account can see data only for studies to which they are explicitly allowed access; see Granting Data Access to User and Group User Accounts.

PSUB User? - A checkbox column indicating whether or not a user is able to submit PSUB jobs. The user cannot edit the checkbox. The value is set by ocl_add_user.sql.

Report Server Directory- Location for log and output files from Oracle Clinical report jobs. You create the directory as part of setting up the Report Server during Oracle Clinical installation. See the section "Set Up (Each) Reports Server for Access and File Viewing" in the Oracle Clinical Installation Guide.

Note:

The location designation for any report server log directory cannot exceed 35 characters.

Custom Help Directory - Location of company-specific context-sensitive html files, if any.

Default PSUB Printer - The printer to which PSUB print jobs are routed, in uppercase. This response must match the Short Value of an active entry in the PRINT QUEUE NAME local reference codelist.

Default RS Printer - The printer to which print output from a report server job is routed. This response must match the Short Value of an active entry in the PRINT QUEUE NAME local reference codelist. Must be entered in uppercase.

Default PSUB Queue - The designation for the queue in which PSUB batch jobs are executed. This response must match the Short Value of an active entry in the BATCH_QUEUE_NAME local reference codelist. Must be entered in uppercase.

Default Report Server - When the user prepares to submit a report request, this response specifies which report server is offered as the default. This response must match the Short Value of an active entry in the REPORT_SERVER local reference codelist.

Default Job Set Report Server - When the user prepares to submit a job set request, this response specifies which report server is offered as the default. This response must match the Short Value of an active entry in the REPORT_SERVER local reference codelist. See Using Job Sets to Control Execution Order for information on job sets.

Default PSUB Scheduler Report Server - When the user prepares to submit a scheduled PSUB job request, this response specifies which report server is offered as the default. This response must match the Short Value of an active entry in the REPORT_SERVER local reference codelist.

Note:

The location designation for any report server log directory, whether directory path or UNC, cannot exceed 35 characters.

For more information, see:

• Adding a User to a Group User Account
  

Adding a User to a Group User Account

You can add all the users who should have access to the same set of studies, programs, or projects to the same group user account and assign data access to all the users at the same time through the group user account. An individual user can belong to multiple group user accounts.

To add a user to a user group:

1. Navigate to Admin, Users, and then Oracle Accounts. The system opens the Oracle Accounts window.

2. Query for the individual user you want to add to a user group.

3. Click Group Membership. The system displays the Group Membership window.

4. From the Group Membership field's list of values, select the group to which you want to assign the user. To assign the user to multiple user groups, use multiple rows.

5. Save your work.