Postgres Pro
Downloads
Home   >   mailing lists

Re: Query on User account password change details - Mailing list pgsql-admin

From Vipin Madhusoodanan
Subject Re: Query on User account password change details
Date
Msg-id CAPOO3u5Nqn+16PS5=9HNJ3AbG42-GDEWp+xy=UMOnQehudr48A@mail.gmail.com
Whole thread Raw
In response to Re: Query on User account password change details  (Rui DeSousa <rui@crazybean.net>)
List pgsql-admin
Tree view
Thanks much Rui and All for the valuable inputs. Rui's suggested solution would be sufficient for our audit requirement. 

Thank you, 
Vipin 

On Sat, May 8, 2021, 7:59 PM Rui DeSousa <rui@crazybean.net> wrote:


> On May 8, 2021, at 8:55 PM, Ron <ronljohnsonjr@gmail.com> wrote:
>
> The problem with this scheme is that any role with SUPERUSER privs can modify that table.
>

True; and if that is a concern then audit the table from a different system where those superusers do not have access to.



pgsql-admin by date:

Previous
From: Rui DeSousa
Date:
Subject: Re: Query on User account password change details
Next
From: John Scalia
Date:
Subject: Technical guidance for a large partition table