By default, only an administrator account is available in ovirt_engine_history.
Each Virtualization Manager has its own randomly generated password for ovirt_engine_history database.
To get the database password, you have to connect to your RHV / oVirt engine via SSH and run this command:
It is also possible to create read-only user, but this requires configuring the database directly.
There is no tool for creating read-only users in the UI or CLI.
Creating a read-only user in the 'ovirt_engine_history' database
Log in as root on the server where ovirt_engine_history is running
(usually the oVirt Engine VM)
Switch to the 'postgres' user
su - postgres
Connect to the database
psql -d ovirt_engine_history
You should see the following prompt:
ovirt_engine_history=#
Create a user 'xormon_ro'
CREATE ROLE xormon_ro
LOGIN
NOSUPERUSER
NOCREATEDB
NOCREATEROLE
NOREPLICATION;
Set user password
\password xormon_ro
Configure database access
GRANT CONNECT
ON DATABASE ovirt_engine_history
TO xormon_ro;
GRANT USAGE
ON SCHEMA public
TO xormon_ro;
GRANT SELECT
ON ALL TABLES IN SCHEMA public
TO xormon_ro;
Get location of 'pg_hba.conf'
This will be needed in a later step
SHOW hba_file;
Quit from psql
\q
Logout
exit
Allow access for 'xormon_ro' from XorMon appliance in 'pg_hba.conf'