LOG_QUERIES
Provides summary information about some queries related to authentication and security run in your database.
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. |
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)