Oracle Cloud Infrastructure Documentation

Reset the Password for 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 custom schemas 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 custom 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 custom schemas.

You can change the password for the 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.

  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 a custom schema:
    Alter user <custom schema name> identified by <Password>;