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:
|
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. |
Example
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)