Creating a read-only user account for Experience Portal local Postgres database

Last Updated : Jan 04, 2021 |
Prolog information
Use this procedure to create a read-only (report) user account for the Experience Portal local Postgres database.
For more information about this procedure, see Configuring the PostgreSQL database user accounts in the Administering Avaya Aura® Experience Portal guide.
  1. Log in to the primary Experience Portal Manager CLI.
  2. Run the following command to switch to the root user:
    ADDITIONAL INFORMATION:
    su - root
  3. Run the following command:
    ADDITIONAL INFORMATION:
    cd /opt/Avaya/ExperiencePortal/Support/Security-Tools
  4. Run the following command to create a read-only (report) user account for the Experience Portal local Postgres database:
    ADDITIONAL INFORMATION:
    ./SetDbPassword.sh add_report_r -u <user name>
    Where, <user name> is a user name for the new read-only user account.
  5. At the Please enter the password prompt, type a password for the read-only (report) user account and press Enter.
  6. After the user account is successfully created, the system shows the following message indicating the list of services to be restarted:
    ADDITIONAL INFORMATION:
    The following services will be restarted automatically:
    - postgresql
  7. Press Y to restart the service.