public inbox for [email protected]
help / color / mirror / Atom feedFrom: 張宸瑋 <[email protected]>
To: [email protected]
Subject: PostgreSQL Account and Object Timestamp Logging
Date: Fri, 19 Sep 2025 10:55:58 +0800
Message-ID: <CAFsaSDg38kUpSurRhzFJa58yYdcc8PXxMi6TXoW3_iJyvdgDWw@mail.gmail.com> (raw)
Hello everyone,
I would like to ask if there are any built-in features or extensions in
open-source PostgreSQL—aside from the AUDIT mechanisms—that allow us to
query or log the creation time of user accounts and database objects.
The reason for this inquiry is that while audit logs do capture these
events, they may eventually be rotated out or removed due to housekeeping
policies. Having a dedicated table or view to permanently record the
creation or modification time of accounts and objects would be very helpful
for audit and security compliance purposes.
Thank you in advance for your insights!
view thread (3+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: PostgreSQL Account and Object Timestamp Logging
In-Reply-To: <CAFsaSDg38kUpSurRhzFJa58yYdcc8PXxMi6TXoW3_iJyvdgDWw@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox