1. Administering Oracle Fusion Analytics Warehouse
  2. Set Up Oracle Fusion Analytics Warehouse
  3. Reset the Password for OAX_USER and Custom Schemas

Reset the Password for OAX_USER and Custom Schemas

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

You can create custom schemas to meet your customization requirements. 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. Initially, the password for these default schemas is the same. However, because of the Oracle Autonomous Data Warehouse security policy, the passwords for the default schemas and custom schemas expire every 365 days. You must change the password every year.

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 ADMIN schema.

You can change the password for the OAX_USER and other custom schemas using either SQL Developer or the Oracle Cloud Infrastructure Console. To change the password using SQL Developer, sign in to SQL Developer using the credentials of the ADMIN schema and run the command that is suggested to use while changing the password from the Oracle Cloud Infrastructure Console.

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.
  3. On the instance details page, click the URL of the Oracle Autonomous Data Warehouse instance.
  4. On the Oracle Autonomous Data Warehouse instance details page, click Database Actions. At this point, you need to sign in to the database using the ADMIN schema credentials.
  5. On the Database Actions page, click SQL and run the following command to change the password for OAX_USER:
    Alter user OAX_USER identified by <Password>;

    Change OAX_USER schema password in Oracle Cloud Infrastructure Console.

    To change the password for a custom schema, run this command: 
    Alter user <custom schema name> identified by <Password>;