CONFIGURATION_CHANGES
Records the change history of system configuration parameters.
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
| Column Name | Data Type | Description |
|---|---|---|
EVENT_TIMESTAMP |
TIMESTAMPTZ | Time when the row was recorded. |
NODE_NAME |
VARCHAR | Name of the node that is reporting the requested information. |
USER_ID |
INTEGER | Identifier of the user who changed configuration parameters. |
USER_NAME |
VARCHAR | Name of the user who changed configuration parameters at the time Vertica recorded the session. |
SESSION_ID |
VARCHAR | Identifier for this session. This identifier is unique within the cluster at any point in time but can be reused when the session closes. |
PARAMETER |
VARCHAR | Name of the changed parameter. See Configuration parameters for a detailed list of supported parameters. |
VALUE |
VARCHAR | New value of the configuration parameter. |
Privileges
Superuser