Monitoring Changes to Configuration Parameters

Jim Knicely authored this tip.

The CONFIGURATION_CHANGES system table records the change history of system configuration parameters. This information is useful for identifying:

  • Who changed the configuration parameter value
  • When the configuration parameter was changed
  • Whether nonstandard settings were in effect in the past

Example:

dbadmin=> ALTER DATABASE sfdc SET EnableSSL = 1;
WARNING 4324:  Parameter EnableSSL will not take effect until database restart
ALTER DATABASE

dbadmin=> SELECT event_timestamp, user_name, parameter, value FROM configuration_changes WHERE parameter = 'EnableSSL';
        event_timestamp        | user_name | parameter | value
-------------------------------+-----------+-----------+-------
 2018-06-03 16:19:42.275319-04 | dbadmin   | EnableSSL | 1
(1 row)

Have Fun!

Sign In or Register to comment.