Vertica Quick Tip: 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!