The shop's reports are built by a separate program. It got a role called report, read access to the orders table, and a password in ~/.pgpass. The administrator who set this up says the line in pg_hba.conf was added and the rules reloaded. The report still fails: the program's log shows a refusal from the server.
Find out at which check it stops, and open access for report as narrowly as for shop.
Let the reports into the shop database
Make the report role log in to the shop database from 127.0.0.1 with the password from ~/.pgpass. Keep report out of other databases, keep shop and crm working, and do not restart the server.
Goals · 0 of 3
- Let report into the shop database with its password not done yet
- Keep report out of the crm database not done yet
- Keep shop and crm working without a restart not done yet