Analytics Warehouse provides default schemas (also known as users) such as the
ADMINschema enables you to access the Oracle Autonomous Data Warehouse instance associated with your Oracle Fusion Analytics Warehouse instance. The
OAX_USERschema 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.
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
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
To change the password for the
schema, see Update the Administrator Password for Oracle Autonomous Data Warehouse.
- Sign in to the Oracle Cloud Infrastructure Console.
- Navigate to your Oracle Fusion Analytics Warehouse instance details page.
- On the instance details page, click the URL of the Oracle Autonomous Data Warehouse instance.
- 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
- 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>;
To change the password for a custom schema, run this command:
Alter user <custom schema name> identified by <Password>;