In addition to what Andreas has suggested, you should also verify user claims by A. Have them show you the query they executed, B. Verify they have appropriate SELECT, INSERT, UPDATE ad/or DELETE permissions on the tables involved.
On Tue, Apr 9, 2019 at 6:10 AM Achilleas Mantzios < ach...@matrix.gatewaynet.com> wrote: > On 9/4/19 12:26 μ.μ., Karl Martin Skoldebrand wrote: > > Hi, > > > > Is there a way to track “transactions” by default (i.e. without anyone > having set up anything specific). The problem I am facing is that users are > claiming that settings are disappearing with them doing anything to affect > them. It would be good to be able to see what postgresql thinks is going on. > > **Subscriber adds Severity/BU/Service by ticking the corresponding box in > subscriber configuration in WEBAPP. This works for some time.* > > **Subscriber stops receiving selected [tickets].* > > **Upon checking settings the selected Severity/BU/Service has been > unselected.* > > > If what you need is business-like trail to specific relations (tables) > (most probably what you need) then you may find pgaudit very useful. Its > author dwsteele also wrote pgbackrest, as a tool it works wonders and the > support is superb. > > > > /M. > > > > > ============================================================================================================================ > > Disclaimer: This message and the information contained herein is > proprietary and confidential and subject to the Tech Mahindra policy > statement, you may review the policy at > http://www.techmahindra.com/Disclaimer.html externally > http://tim.techmahindra.com/tim/disclaimer.html internally within > TechMahindra. > > > ============================================================================================================================ > > > > -- > Achilleas Mantzios > IT DEV Lead > IT DEPT > Dynacom Tankers Mgmt > > -- *Melvin Davidson* *Maj. Database & Exploration Specialist* *Universe Exploration Command – UXC* Employment by invitation only!
