Create an Ops Insights Warehouse Database User

You need to create a warehouse database user who will have read-only access and access to the dbms_workload_repository PL/SQL package to run AWR reports.

  1. Click the Warehouse Database Users tab.
  2. Click Create User. The Create Warehouse Database User page displays.
  3. Enter a User Name and Password.
    Note

    Password must be 12 to 30 characters and contain at least one uppercase letter, one lowercase letter, and one number. The password cannot contain the double quote (") character or the username entered above. It must be different than the last four passwords. You cannot reuse a password within 24 hours.
  4. Select an Access type. Click AWR Hub.
  5. Click Create User.