public inbox for [email protected]  

help / color / mirror / Atom feed

Ensure 'User' Runtime Parameters are Configured
2+ messages / 2 participants
[nested] [flat]

* Ensure 'User' Runtime Parameters are Configured
@ 2024-10-07 08:33 pramod kg <[email protected]>
  2024-10-08 03:20 ` Re: Ensure 'User' Runtime Parameters are Configured Muhammad Usman Khan <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: pramod kg @ 2024-10-07 08:33 UTC (permalink / raw)
  To: Pgsql-admin <[email protected]>

Hi All,

There is a requirement to monitor run time parameters and revert back
changes (As per CIS Benchmark report). Requirement is to monitor user
session parameter changes. How to achieve this? Any guidance is appreciated

Complete remediation given by CIS benchmark is as follows:

In the matter of a user session, the login sessions must be validated that
it is not executing
undesired parameter changes. In the matter of attributes that have been
changed in
entities, they must be manually reverted to its default value(s).


Regards,
Pramod


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Ensure 'User' Runtime Parameters are Configured
  2024-10-07 08:33 Ensure 'User' Runtime Parameters are Configured pramod kg <[email protected]>
@ 2024-10-08 03:20 ` Muhammad Usman Khan <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: Muhammad Usman Khan @ 2024-10-08 03:20 UTC (permalink / raw)
  To: pramod kg <[email protected]>; +Cc: Pgsql-admin <[email protected]>

Hi,
There is not a predefined method to achieve this but you can get your
desired output by implementing the following logics:

   -   Enable Detailed Logging by setting the following parameters in
   postgresql.conf file:
     logging_collector = on
     log_statement = 'all'
     log_duration = on
   -   Implement Auditing with pgaudit
   -   Restrict Privileges
   -   Automated Reversion:
     Schedule a job that compares current settings with default_parameters
   and reverts any discrepancies.



On Mon, 7 Oct 2024 at 13:33, pramod kg <[email protected]> wrote:

> Hi All,
>
> There is a requirement to monitor run time parameters and revert back
> changes (As per CIS Benchmark report). Requirement is to monitor user
> session parameter changes. How to achieve this? Any guidance is appreciated
>
> Complete remediation given by CIS benchmark is as follows:
>
> In the matter of a user session, the login sessions must be validated that
> it is not executing
> undesired parameter changes. In the matter of attributes that have been
> changed in
> entities, they must be manually reverted to its default value(s).
>
>
> Regards,
> Pramod
>


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2024-10-08 03:20 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-10-07 08:33 Ensure 'User' Runtime Parameters are Configured pramod kg <[email protected]>
2024-10-08 03:20 ` Muhammad Usman Khan <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox