LOG_PARAMS

Provides summary information about changes to configuration parameters related to authentication and security run in your database.

Column Name Data Type Description
ISSUED_TIME VARCHAR The time at which the query was executed.
USER_NAME VARCHAR Name of the user who issued the query at the time Vertica recorded the session.
USER_ID INTEGER Numeric representation of the user who ran the query.
HOSTNAME VARCHAR The hostname, IP address, or URL of the database server.
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.
AUDIT_TYPE VARCHAR

The type of operation for the audit, in this case, Parameter.

AUDIT_TAG_NAME VARCHAR The tag for the specific parameter.
REQUEST_TYPE VARCHAR

The type of query request.
REQUEST_ID INTEGER Unique identifier of the query request in the user session.
SUBJECT VARCHAR The new value of the parameter.
REQUEST VARCHAR Lists the query request.
SUCCESS VARCHAR Indicates whether or not the operation was successful.
CATEGORY VARCHAR The audit parent category, such as Authentication.

Example

The following example queries the LOG_PARAMS system table and shows only the most recent configuration parameter for this user under the Authentication category: 

=> SELECT * FROM log_params limit 1;
--------------------------------------------------------------------------------------------------------
issued_time   | 2018-02-12 13:41:20.837452-05 
user_name     | dbadmin    
user_id       | 45035996273704962
hostname      | ::1:50690          
session_id    | v_vmart_node0001-341751:0x13878 
audit_type    | Param
audit_tag_name| SecurityAlgorithm 
request_type  | UTILITY 
request_id    | 8
subject       | MD5                
request       | select set_config_parameter('SecurityAlgorithm','MD5',null);
success       | t        
category      | Authentication
(1 row)