Oracle Cloud Infrastructure Documentation

Reset the Password for OAX_USER Schema

Oracle Fusion Analytics Warehouse provides default schemas (also known as users) such as the ADMIN schema and OAX_USER schema.

From release Platform 23.R4 onwards, Oracle Fusion Analytics Warehouse provides only OAX_USER as the default schema and you can only use OAX_USER during instance creation.

The ADMIN schema enables you to access the Oracle Autonomous Data Warehouse instance associated with your Oracle Fusion Analytics Warehouse instance. The OAX_USER schema enables you to run your own SQL queries against the database or sign in and view the data in the tables of the associated Oracle Autonomous Data Warehouse instance. The security policy of Oracle Autonomous Data Warehouse requires you to change the passwords for the default schemas every 365 days.
Note

You need to be either an Oracle Cloud Infrastructure administrator or an administrator user with the necessary privileges to sign in and reset the password for the OAX_USER schema.

To change the password for the ADMIN schema, see Update the Administrator Password for Oracle Autonomous Data Warehouse.

  1. Sign in to the Oracle Cloud Infrastructure Console.
  2. Navigate to your Oracle Fusion Analytics Warehouse instance details page and click Update password.
  3. In the Update Autonomous Data Warehouse Credentials dialog, in Username, select OAX_USER, enter a password, confirm the password, and then click Save Changes.

    Update OAX_USER password