CONFIGURATION_CHANGES
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 in the Administrator's Guide for a detailed list of supported parameters. |
VALUE |
VARCHAR |
New value of the configuration parameter. |
Privileges
Superuser