1. Administrator's Guide
  2. Configuration Tasks
  3. Setting Up User Accounts
  4. Changing Passwords

Changing Passwords

Changing passwords depends on whether they are for a schema, a role, or for a user.

Note:

Passwords can contain only these special characters: ~ # ^ - _ + :

Passwords cannot contain these special characters: & ( ) ' % @ { } | ; , $ . * " < > ? ` ! [ / \ ] =

Passwords are case-sensitive starting from this release.

For more information, see:

Parent topic: Setting Up User Accounts

Changing the Password for a User

Users can change their own database passwords either in SQL*Plus or with the Oracle Clinical menu by choosing Admin, then Users, and then Database Password.

In the Oracle Database Password window:

  1. Type your password in Enter Password text box.

  2. Type it again in the Confirm Password text box.

  3. Click OK.

Administrators can change the password for an Oracle Clinical user in SQL*Plus as usual:

  1. In SQL*Plus, connect to the database as the SYSTEM user.

  2. Reset the password for the user:

    alter user user identified by user_password;

Parent topic: Changing Passwords

Changing the Password for a Schema or Role Using the SET_PWD Utility

The following table lists the Oracle Clinical database objects that are protected by encrypted passwords stored in two locations:

  • An Oracle dictionary table

  • An Oracle Clinical passwords table

Use the SET_PWD utility to change the passwords for these accounts, encrypt the new password, and store it in both locations.

Log in to the database server and from the Windows command prompt or UNIX command line, run opa_setup with the required parameters before executing set_pwd.

set_pwd has the following two scenarios:

  • Scenario 1: set_pwd rxc db_object_name
  • Scenario 2: set_pwd rxc/rxc_password db_object_name db_object_password

    Note:

    Scenario 2 does not protect the password.

Where db_object_name is the name of the schema or role from changing-passwords.html#GUID-A9D072D9-E4CB-45EA-AB96-314B50FB9C4B__BABFAFFJ.

Example 1:

$ set_pwd rxc rxc_pd

Enter RXC Password

Enter RXC_PD Password

Password successfully encrypted and stored.

Example 2:

set_pwd rxc/your_rxc_password rxc_pd your_rxc_pd_password

Password successfully encrypted and stored.

Note:

The Oracle Database DEFAULT profile, which applies to all users by default, including these internal roles and schemas, enforces password requirements including an expiration period. You must proactively change their passwords before they expire, or parts of the system will stop working.

In rare cases you may want to change the password of the Wallet itself. See Oracle Fusion Middleware Administrator's Guide for more information. You must then change the passwords for the accounts.

Table 1-4 Password-Protected Database Objects

Name Type Description

RXC_MAA

Schema

Required for Data Extract.

RXC_PD

Schema

Required for Procedure generation.

Parent topic: Changing Passwords

Synchronizing Passwords in the WebLogic Admin Server

The passwords for the application middle tier account, RDC_MIDTIER_PROXY, must be changed to the same value in the following places:

Parent topic: Changing Passwords

Auditing Passwords

Oracle recommends that you turn on the auditing system for roles. For information on the AUDIT command, see the Oracle SQL Reference manual.

To track failed attempts to create, alter, drop, or set a role, issue the following statement:

audit role by access whenever not successful

Parent topic: Changing Passwords

Changing the Password for the OCPSUB

The passwords for OCPSUB is stored in Oracle Wallets on the database. You cannot use the set_pwd utility to change these passwords. Instead, do the following:

  1. Log on as opapps.

  2. Set environment variables for the database name and code environment; see Setting Environment Variables on the Command Line

  3. Open an MS-DOS window.

  4. Set the server environment; see Setting Environment Variables on the Command Line

  5. Enter the following command, where wallet_location is the full path to the wallet: 

    mkstore -wrl wallet_location - modifyCredential tns_names_entry OCPSUB_or_RXC_DISC_REP  new_password

  6. The system prompts you for the wallet password.

Parent topic: Changing Passwords