LOG_QUERIES

Provides summary information about some queries 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, Query.
AUDIT_TAG_NAME	VARCHAR	The tag for the specific query.
REQUEST_TYPE	VARCHAR	The type of query request. Examples include, but are not limited to: QUERY DDL LOAD UTILITY TRANSACTION PREPARE EXECUTE SET SHOW
REQUEST_ID	INTEGER	The ID of the query request.
SUBJECT	VARCHAR	The subject of the query.
REQUEST	VARCHAR	Lists the query request.
SUCCESS	VARCHAR	Indicates whether or not the operation was successful.
CATEGORY	VARCHAR	The audit parent category, such as Managing_Users_Privileges.

Examples

The following example queries the LOG_QUERIES system table and shows only the most recent query for this user under the Managing_Users_Privileges category:

=> SELECT * FROM log_queries limit 1;
---------------------------------------------------------------------------

issued_time   | 2018-01-22 10:36:55.634349-05
user_name     | dbadmin
user_id       | 45035996273704962
hostname      |
session_id    | v_vmart_node0001-237210:0x37e1d
audit_type    | Query
audit_tag_name| REVOKE ROLE
request_type  | DDL
request_id    | 2
subject       |
request       | revoke all privileges from Joe;
success       | f
category      | Managing_Users_Privileges
(1 row)